Tag Archives: monitor

TSQL – Monitor to check number of records every hour in a given table

Posted in Azure, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

Blocking Monitor and alert

I have created following blocking monitor which will monitor and alert if threshold is crossed. We can pass the parameters when the alert to be triggered (Number of blockings and number of seconds the blocking persists). I have configured a … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , | Leave a comment

Long running job monitor – Alert

I have created this script which will monitor long running jobs and alerts the analyst. One advantage of this custom script is to find threshold dynamically using job history! – Vijred

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment