Poor performance on SQL 2000 Clustered

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

salva.gomez@gmail.com - 29 Sep 2006 12:24 GMT

Hi all,
i have a 2-node cluster with SQL 2000. I've received many complaints
about the performance. My users tell me that the server is very slow.
The boxes are new (2 cPu Intel Xeon 2'8 GHZ and 4 Gb RAM, ...)
I have used PerfMon to see tipical counters and have seen about 100
page error/sec in memory counter.

In task manager i can see CPU about 4% CPU time and the system has
about 1'5 Gb RAM free.

How can i increase the performance? How can I review my cluster
configuration to get a better situation? I'm new in clustering and i
want to know how can i do it. URLs, all...

Thanks for your help

Reply to this Message

Andrew J. Kelly - 29 Sep 2006 13:02 GMT

Clustering has nothing to do with performance of SQL Server. It is a
hardware fail over technology only. You need to do some investigation to see
what the issues are. These should get you started:

http://www.sql-server-performance.com/sql_server_performance_audit10.asp
Performance Audit
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_per
fmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types

Signature

Andrew J. Kelly SQL MVP

> Hi all,
> i have a 2-node cluster with SQL 2000. I've received many complaints
[quoted text clipped - 11 lines]
>
> Thanks for your help

Reply to this Message