Posted by Erland Sommarskog on 11/23/05 00:51

Paul (paulwragg2323@hotmail.com) writes:
> I am having a real issue with CPU usage by SQL Server, and it is not
> related to a poor query.
>
> I have a clients database that I am currently investigating some issues
> with. After I perform a standard task using the application, and the
> results have been returned to the application the cpu usage remains at
> 100%.
>
> Even once the application has been completely closed down the cpu usage
> remains at 100%. Nothing else is happening.
>
> I am at a complete loss as to how to proceed to with investigation of
> this issue (i have been looking at this for over a week using SQL
> Server tools and Performance Monitor, and eliminating various other
> possibilities)
>
> I downloaded Process Explorer, and looking at the threads for
> sqlservr.exe there is one in particular that is consuming all of the
> cpu time:
>
> MSVCRT.DLL

Sounds bad.

I would look in the SQL Server error log, to see if there are any
messages.

If this scenario is happen repeatedly, I would consider open a case
with Microsoft, as this sounds like it could be a problem in SQL Server.
That or some hardware problem.

You should of course also make sure with sp_who2 that there are no
active processes. Particularly, watch the CPUTime column, to see if
there is any suspect.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]