SQL Server 2000 on Windows 2000 advanced server sometime slow

Last Post 21 Sep 2007 07:23 PM by yee68. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
yee68
New Member
New Member

--
21 Sep 2007 07:23 PM
We are using SQL Server 2000 SP3 on Windows 2000 Advanced Server 2000 SP3. Hardware is a cluster with two servers: Compaq Proliant DL580 with external storage device Compaq MSL 1000(Raid 5).

Since last week we encountered server become very slow on and off (about 5 times) and manually switch over to another cluster node. After switch over to another cluster, become normal.
Normally, our CPU usage is 10 to 30% on the server. When server slow, CPU usage become 50% and never go down.
We have checked with HP and they said nothing wrong with Hardware. Please advise us how to troubleshoot source of the problem



Acceptable Use Policy
---