SQL Clone
SQLServerCentral is supported by Redgate
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 2015/05/06 | Source: SQLServerCentral.com | Category: cpu issues
Rating: |  Discuss |   Briefcase | 2,911 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,245 reads
   Items 1 to 2 of 2