Alert For Blocking in Azure SQL Managed Instance
-
In an Azure SQL Managed Instance there is no option to create what we might refer to as our 'standard alerts' under sql agent\alerts - there is simply no alerts folder.
On a on premise version of sql server, I would create an alert for blocking and get it to then trigger a sql agent job to gather the blocking info into a table. How do we achieve this within an Azure Managed Instance. There doesn't seem to be anything via the Azure Portal either.
-
Azure SQL MI is restricted in what they support, alerts are generally configured on the MI settings in the portal
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Yeah, that is what I thought but I can't seem to see anything related to blocking - only CPU thresholds, IO alerts and few others. Looks like we will have to rely on a 3rd party monitoring app.
-
sql agent on MI offers less than unmanaged instances
Alerts on MI are created at the Azure resource level, check out alerts and diagnostic settings in Azure portal
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply