sql process take 100% CPU

[fleps]

Hi

I use an sql2000 server to log databases for several mailsweeper, websweeper and 2 other databases.

Sometimes the SQLserver process take 100% of CPU
is there a way to know what is the ODBC connection witch take all the CPU ??

THANKS

FRED

 

[DBADoug]

You might try looking at the spid process from within the Enterprise Manager, and see which ones are taking up the CPU time. (Management/Current Activity/Process Info). This might provide some insight, as you can sometimes see what the last command those spids executed by double clicking it.