Finding CPU Utilization on SQL Server

Run this query to see if there is an increasing amount on a particular SPID

select spid, cpu, physical_io from sysprocesses order by cpu desc

Categories: sql

Be the first to rate this post

05.07.2009 03:59 by Danny Gershman | Comments (0) | Permalink

Deciphering SQL Server Field Length for N typesN types are used for implementing double-byte character sets. This is sometimes used in design...Observer pattern in JavascriptThe observer pattern is extremely powerful in many cases where you want to have a Javascript class “...Finding duplicates with SQLThis is probably one of the most useful pages I’ve ever used on the Internet http://www.petefreitag...

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website

Enter Numbers In Image Above: b i u quote

Notify me when new comments are added