The most recent content from our members.
We've had a couple issues where SQL services do not come back online after patching/server restart/etc. The SQL Offline alert does not fire because it never started up in the first place. It would be good if the alert covered that scenario as well.
There are some alerts related with only blocking duration (under General Conditions, SQL Server: Blocking SQL, SQL Server: Blocking SQL Duration Threshold Max), not for blocking count. If blocking count greater than 5-10 it could be critial issue and it may cause increase active session count and server resource…
It looks like you're new here. Sign in or register to get started.