sqlservr.exe usages 100% CPU

hi 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




karzon
karzonr@gmail.com

If you have less than 1000 batch/sec request on this server then you run SQL profiler trace with RPC start and RPC complete enabled during this peaks and then check the trace file to indetify the causing it.

Also check perfmon for signs sql compilations/sec.

Cheers
Sat

Some useful cases discussed in this forums earlier can also serve as guide

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19594

Cheers
Sat