2

I am currently using Microsoft Azures elastic pool to allocate resources to my databases as needed, however for my purposes at the moment the cost is too high for the amount of traffic the databases are handling. My question is if I removed the databases from the elastic pool and delete it will I need to update the SQL queries in my codebase?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
Alan
  • 302
  • 5
  • 22
  • To be clear, you are running an Elastic Pool that contains several databases, and you want to remove the databases from the pool and have them each be billed as a single instance? You then want to delete the entire elastic pool, correct? – Rob Reagan Aug 11 '17 at 14:55
  • 1
    I would not expect you would need to change any query. Elastic pools are meant to be for managing the pool of resource to distribute among the databases as and when needed. Moving the database in the pool as well as out is supported which does not indicate any need to update the application (or query). I would suggest move a database out from the pool and test few queries to rule out any 'What If' in the mind. – Sujit Singh Aug 11 '17 at 16:59
  • 1
    @SujitSingh, please post your comment as the answer. It is correct and should be accepted in case anyone else is searching for the same information. – Rob Reagan Aug 12 '17 at 17:26

1 Answers1

1

I would not expect you would need to change any query. Elastic pools are meant to be for managing the pool of resource to distribute among the databases as and when needed. Moving the database in the pool as well as out is supported which does not indicate any need to update the application (or query). I would suggest move a database out from the pool and test few queries to rule out any 'What If' in the mind

Sujit Singh
  • 799
  • 6
  • 11