exec admin.dbo.usp_serverblocks @orderby = 'secprocessortime'
January 05, 2012
Find out what is causing CPU use in SQL Server
Here is a snippet shared by a co-worker for finding out what processes are eating cpu resources on SQL Server.
exec admin.dbo.usp_serverblocks @orderby = 'secprocessortime'
exec admin.dbo.usp_serverblocks @orderby = 'secprocessortime'
Subscribe to:
Posts (Atom)