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:
Post Comments (Atom)
No comments:
Post a Comment