Poor performance on SQL 2000 Clustered

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
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.co...ce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pro...perations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Andrew J. Kelly SQL MVP
<salva.gomez@.gmail.com> wrote in message
news:1159529059.960231.275970@.m73g2000cwd.googlegr oups.com...
> 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
>
sql

PollingInterval

Does the PollingInterval parameter on the LogReader and Distribution Agent
need to be the same? I've found that if I don't change the default in the
job (no parameter) for the LogReader Agent and I include the parameter in the
job for the Distribution Agent, the Distribution Agent just hangs on Step1
(Starting agent).
Thanks,
Mark
they don't have to be the same, but ideally the log reader agent should be
more than the distribution agent. I have not noticed them hanging.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:E8218B91-B40F-46A9-BFA2-AFE3383C3FD5@.microsoft.com...
> Does the PollingInterval parameter on the LogReader and Distribution Agent
> need to be the same? I've found that if I don't change the default in the
> job (no parameter) for the LogReader Agent and I include the parameter in
> the
> job for the Distribution Agent, the Distribution Agent just hangs on Step1
> (Starting agent).
> Thanks,
> Mark

please interpret this delete with 2 from clauses

I pretty much think I know what this does, but I've never seen a
DELETE statement with 2 FROM clauses:
delete from #acc
from ggg d
where #acc.id=d.nbr
and d.oid='294'
I think this is the same as
DELETE FROM #acc
WHERE #acc.id IN
(SELECT nbr FROM ggg d
WHERE d.oid ='294' )
but it never hurts to make sure
On Sat, 30 Jun 2007 14:10:23 -0000, metaperl <metaperl@.gmail.com>
wrote:

>I pretty much think I know what this does, but I've never seen a
>DELETE statement with 2 FROM clauses:
>delete from #acc
> from ggg d
> where #acc.id=d.nbr
> and d.oid='294'
The first FROM is optional, and most examples in this group don't use
it.

>I think this is the same as
>DELETE FROM #acc
>WHERE #acc.id IN
> (SELECT nbr FROM ggg d
> WHERE d.oid ='294' )
Yes, that does the same thing. So does:
DELETE FROM #acc
WHERE EXISTS
(SELECT * FROM ggg d
WHERE d.oid ='294'
AND #acc.id = nbr )

>but it never hurts to make sure
Especially with DELETE!!! 8-)
Roy Harvey
Beacon Falls, CT