|
Home > Archive > MS SQL Server > July 2005 > Unknown process consuming excess CPU time
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unknown process consuming excess CPU time
|
|
| Jeff Bowman 2005-07-16, 7:23 am |
| About 30 hours ago we lost power, and my SBS 2003 server (Exchange, SQL 2000)
went down without a proper shutdown. (The duration of the power loss exceeded
the battery backup length, and I wasn't able to get to the server in time.)
It took a couple of restarts to get all the services starting and functioning
correctly again, but something's still not right.
Ever since the first startup after the plug was pulled, some process has had the
hard drive churning constantly and the CPU consumed steadily at between 75% and
85%. In Task Manager, the red Kernel Times line shadows continually just under
the green CPU Usage line.
The trouble is, nothing shows up in the Process List as consuming these
resources. The System Idle Process weighs in at a roughly consistent 70-75% or
so, with miscellaneous other tasks alternating in and out underneath it when the
list is sorted in descending order by the CPU column.
I recall similar behavior when I installed SQL Server 2000 SP4 (this is why I'm
cross-posting to the SQL Server group), and so my first thought was that the SQL
Service was re-indexing the databases. At that time, however, I had a 14GB
database, so I could understand it taking more than 24 hours.
But right now I have only six databases totaling 140MB. If there were some
reindexing going on, surely it would've finished after 30+ hours, yes? Is it
Exchange, rebuilding its database? Only 1.5GB there, and Exchange has been
working fine since the incident.
Does anyone know how I can go about finding out what this process is, so I can
proceed and troubleshoot from there?
TIA,
Jeff
| |
|
| Hi Jeff,
Im no expert and am probably a way off the mark here but I have seen
checkdisk run in the background from this length of time after an unplanned
shutdown due to the size of my hard disks.
Cheers
Scott
| |
| Jeff Bowman 2005-07-16, 8:23 pm |
| That's a good point, I didn't consider that.
Apparently whatever it was must have been doing something good, because it was
back to normal this morning.
scott wrote:
> Hi Jeff,
>
> Im no expert and am probably a way off the mark here but I have seen
> checkdisk run in the background from this length of time after an unplanned
> shutdown due to the size of my hard disks.
>
> Cheers
> Scott
|
|
|
|
|