|
|
Posted by Paul on 11/22/05 12:37
Hi
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
I am running SQL Server 2000 SP4 on the following machine:
Windows 2000 SP4
Pentium 4 3Ghz (Note this is seen as 2 processors so the reported cpu
usage is 50%)
1Gb Memory
I also have about 20Gig of free disk space.
One other thing, the page faults reported on the Performance tab of
Process Explorer exceeds 3 million. This is after running the
application for around 10 minutes.
Please can anybody suggest anything at all that might help? I'm sorry
there is not too much information in here but I have not been able to
find out anything useful!
Many Thanks in advance.
Paul
Navigation:
[Reply to this message]
|