Alert for max storage on elastic pool and used space percentage on Azure SQL databases

[AlreadyPicked]

I would like have alerts when max storage on an elastic pool is attained and also the used space percentage for all my Azure SQL databases.

I was able to create this with custom performance counters for my SQL instances but on Azure SQL, because the master database can't execute procedures on other databases, I could not find a way to do it.

Some of those values are already available as checks but I could not find a way to add alarms to checks.

Could you point me in the right direction?

[DavidWiseman]

Ideally you want to deal with space issues as part of your daily checks (Summary page). Fixing the problem before you get a critical disk space notification at the weekend is ideal. Sometimes unexpected growth can occur so having an alert notification trigger at a slightly higher threshold is a good thing to have in addition to daily checks. There isn't an alert type for this at the moment.

For any alerts you want to create that are not an alert type in DBA Dash, you can create an agent job that fails based on your alert criteria then create and alert on the agent job failure.

e.g.

IF EXISTS(
	SELECT * 
	FROM dbo.AzureDBElasticPoolResourceStats_Current
	WHERE avg_allocated_storage_percent > 90
	)
BEGIN
	RAISERROR('Azure DB Elastic Pool storage limit is over the specified threshold',11,1)
END

IF EXISTS(
	SELECT * 
	FROM dbo.AzureDBInfo
	WHERE AllocatedPctOfMaxSize>0.9
)
BEGIN
	RAISERROR('Azure DB storage limit is over the specified threshold',11,1)
END

Hope this helps.