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
Posted Tuesday, March 25, 2014 3:32 PM



Group: General Forum Members
Last Login: Yesterday @ 12:13 PM
Points: 15,976, Visits: 30,338
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
SQL Server Execution Plans

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

Add to briefcase ««12

Permissions Expand / Collapse