Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Uday Reddy

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Capture current queries when cpu is above certain threshold

If you get alerts for high CPU, but by the time you login/check the server cpu is back to normal, then use this sp to create a sql agent job and run it every min.  Read more...
By Uday Reddy 2013/06/28 | Source: SQLServerCentral.com | Category: cpu issues
Rating: |  Discuss |   Briefcase | 1,669 reads

Monitor current transactions and get all required information

Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.  Read more...
By Uday Reddy 2013/03/25 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 2,115 reads
   Items 1 to 2 of 2