W2000 Adv ServSP2 +SQL7SP4 100% CPU Spin

[JMAPUK]

I am currently running a Windows 2000 Advanced Server with 8 Zeon 900Mhz CPU's with 4gb of RAM, this server also hosts MS SQL7 and has 4 internal 36.4gb Ultra 3 scsi HD's Mirrored & striped, also has an external Raid5 array fully populated with 14 36.4gb HD's supporting about 500 users, the problem I am getting is the server can be up for about a day and all of a sudden all 8 CPU's max out at 100%, I have by process of elimination stopped services one by one (only leaving the SQLServer service running) the processors stay at 100%, upon stopping SQLServer service CPU's dropped off, also my pagefile's are sat on my C<drive> and P<Drive> c = 48mb - 128mb p = 5048, what I am trying to find out is why my CPU's jump to 100% and what should my Pagefiles be and do they swap between to two. Also I have put SP4 for SQL on about 2 weeks ago, before then I didn't have this problem.

 

[Hungster]

Q295034

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q295034

i know this is for SQL 2000, but it will be more less simular in some services

 

[GlenJohnson]

I've been having the same issue for months. Working with ms now. I have task manager open, and I sort by cpu usage. It is almost always services.exe which hangs the server. Problem is, that always runs, and is called when a program is called. Services.exe is used to load the program. I know this doesn't help, but just wanted to let you know your'e not alone. I have an alert set up on the server so that when cpu gets over 80%, it sends me a message. I'm logging this info and trying to see if there's any rhyme or reason. Good luck. Glen A. Johnson
Microsoft Certified Professional
glen@nellsgiftbox.com


&quot;Knowledge of the world is only to be acquired in the world, and not in a closet.&quot;
Lord Chesterfield 1694-1773); English statesman.