Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How fast can I know that the server is going down or is down Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 3:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 14,205, Visits: 28,536
If you really want to do it all manually, I'd look up one of the blocking scripts that are posted online here. Get a newer version for 2008 , not one of the old 2000 ones that are still hanging around.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1554708
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse