SQL Server 2000 Cluster very slow sometime

[yee68]

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

 

[mrdenny]

What else is running and taking CPU resources on the machine when it has a problem?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[yee68]

Thanks for your reply. No other application or services are running except cluster for file group and SQL Server Group and services relating to SQL Server.

 

[mrdenny]

Does task manager show that SQL is taking all the resources, or is defrag running (as an example) and taking CPU resources?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com