SQL Server Performance Forum – Threads Archive
sqlservr.exe usages 100% CPUhi there,
I’ve a SQL server 2005 Enterprise (x64 bit) on windows server 2003 Ent (x64 bit).
Recently the SQL server run very Slow. From Task Manager I found the sqlservr.exe process usages CPU 80% to 100% . The problem is going on constantly. What is the cause and how to solve the problem.
Plz help me. Thanks
Take help of thishttp://sqlserver-qa.net/blogs/perftune/archive/2007/04/26/high-cpu-spikes-affecting-performance.aspx and alsohttp://sqlserver-qa.net/blogs/perftune/archive/tags/performance/default.aspx for relevant checkout blogs. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.