sql server 2000 clustering montoring -- sql server clustering

Ritesh Gupta
7/20/2004 10:07:01 PM

Thanks Rod ,
I think this will work for standalone SQL Server . How counter and threshold will differ in case of Clustered SQL Server .

[quoted text, click to view]

Rodney R. Fournier [MVP]
7/21/2004 7:09:24 AM

Ritesh,

I still would recommend you monitor:
Memory - Pages/sec

. Network Interface - Bytes total/sec

. Physical Disk - Disk Transfers/sec

. Processor - % Processor Time

. SQLServer:Access Methods - Full Scans/sec

. SQLServer:Buffer Manager - Buffer Cache Hit Ratio

. SQLServer:Databases Application Database - Transactions/sec

. SQLServer:General Statistics - User Connections

. SQLServer:Latches - Average Latch Wait Time

. SQLServer:Locks - Average Wait Time

. SQLServer:Locks - Lock Timeouts/sec

. SQLServer:Locks - Number of Deadlocks/sec

. SQLServer:Memory Manager - Memory Grants Pending

SQL on a cluster is like SQL on a stand alone. In both cases you monitor the
above.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

[quoted text, click to view]

uttamkp NO[at]SPAM online.microsoft.com
7/21/2004 3:47:50 PM

Ritesh,

I agree with Rod.

If you want some more information, another good resource is "Chapter 15 - Monitoring for High Availability" in
Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Ritesh Gupta
7/21/2004 9:59:02 PM

Hi ,
ROD thanks

Do we to apply all these on virtual server or on each nod

Ritesh

[quoted text, click to view]

Rodney R. Fournier [MVP]
7/22/2004 7:00:50 AM

Any node that is hosting an instance.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : sql server 2000 clustering montoring