Post reply

cpu usage at 100% being consumed by system idel process

  • December 13, 2005 at 10:56 am

    #111113

    I have a Win 2000 service pack4 server running sql service pack 4.  The operating system files are on the C: drive and the database files are on the D: drive.  I performed a defrag yesterday on the D: drive and now when sql server is running, system idle process shows 99% causing the cpu usage to run at 100% with no other programs running.  If I stop sql server, the system idle process still shows 97 to 99% but the cpu % drops to almost nothing.

     

    Any suggestions?

  • December 13, 2005 at 12:25 pm

    #609292

    I'm gonna answer this one myself.  I have a remote server that utilizes a database on the D: drive of the sql server.  I apparently did not disconnect from the database when doing the defrag so the remote machine still had a hold on the sql database.  I rebooted the remote server and the sql box is now running at optimal spped.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply