Detect and Alert DBA of Blocking SPIDS
This script will detect and alert the DBA of blocking processes. The DBA can adjust the length of time the block has exisited before sending the net send message.
2001-08-29
5,143 reads
Blogs
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
SQLSaturday Orlando Notes – Coffee
By Andy Warren
I like to say that the goal for any event is to meet the...
Forums
result in same line
Hello, trying to query the result by success or failure in 2 seperate...
Dropping SP's safely
Hi, Is the below script good to delete 3 sp's... Please let me know...
SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working
Hello, I have a Read-Scale AG set up. I have it failing over back...
Ask SSC