Delete Azure Elastic Pools if Empty

Asked Jun 17 '20 at 07:18

Active Jun 18 '20 at 07:41

Viewed 241 times

In C# I am using the Azure fluent API Microsoft.Azure.Management.Fluent to manage resources. I want to be able to delete an Elastic Pool if it is empty (e.g. I have just ran a process that deletes a DB within it).

azure.SqlServers.ElasticPools.DeleteBySqlServerAsync(...

However I have a separate process which depending on user actions might create a database within the pool. So I don't think it is safe for me to get the count of the databases within the pool then delete it if there are zero due to the race condition that might happen between.

Is there anyway, using the Azure fluent api I can safety delete elastics pools only if there is no databases?

edited Jun 18 '20 at 07:41

asked Jun 17 '20 at 07:18

Michael Hancock

2,673
1
18
37

when the elastic pool is deleted if there's no database in it, the separate process create database in specify elastic pool may get error. – Leon Yue Jun 17 '20 at 07:53
I don't want to trigger the delete if a database is in it – Michael Hancock Jun 17 '20 at 08:04

Delete Azure Elastic Pools if Empty

0 Answers0