 | |
sql server 2000 clustering montoring
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
sql server 2000 clustering montoring -
07-20-2004
, 03:56 AM
#2
| |||
| |||
|
|
we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
#3
| |||
| |||
|
|
we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
#4
| |||
| |||
|
|
Thanks Rod , I think this will work for standalone SQL Server . How counter and threshold will differ in case of Clustered SQL Server . "Ritesh Gupta" wrote: we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
#5
| |||
| |||
|
|
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  atabases 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 "Ritesh Gupta" <RiteshGupta (AT) discussions (DOT) microsoft.com> wrote in message news:254ADFAE-42E4-4A94-B799-939AF2167BC5 (AT) microsoft (DOT) com... Thanks Rod , I think this will work for standalone SQL Server . How counter and threshold will differ in case of Clustered SQL Server . "Ritesh Gupta" wrote: we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
#6
| |||
| |||
|
|
Hi , ROD thanks Do we to apply all these on virtual server or on each nod Ritesh "Rodney R. Fournier [MVP]" wrote: 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 atabases 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 "Ritesh Gupta" <RiteshGupta (AT) discussions (DOT) microsoft.com> wrote in message news:254ADFAE-42E4-4A94-B799-939AF2167BC5 (AT) microsoft (DOT) com... Thanks Rod , I think this will work for standalone SQL Server . How counter and threshold will differ in case of Clustered SQL Server . "Ritesh Gupta" wrote: we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
#7
| |||
| |||
|
|
I am having the SQL Server Monitor pack which monitors SQL server performance. Can i apply this pack on virtual clustered SQL server to |
Quote:
|
Do i need to chage the threshod values of performance counters as per the number of nodes present in SQL clustered environment? Thanks in Advance. Ravi "Rodney R. Fournier [MVP]" wrote: Any node that is hosting an instance. Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering "Ritesh Gupta" <RiteshGupta (AT) discussions (DOT) microsoft.com> wrote in message news:979F3DE2-E07D-4345-9F43-07BC5F0623EB (AT) microsoft (DOT) com... Hi , ROD thanks Do we to apply all these on virtual server or on each nod Ritesh "Rodney R. Fournier [MVP]" wrote: 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 atabases 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 "Ritesh Gupta" <RiteshGupta (AT) discussions (DOT) microsoft.com> wrote in message news:254ADFAE-42E4-4A94-B799-939AF2167BC5 (AT) microsoft (DOT) com... Thanks Rod , I think this will work for standalone SQL Server . How counter and threshold will differ in case of Clustered SQL Server . "Ritesh Gupta" wrote: we are using sql server 2000 clustering .Pl help me , tell me about how to moniture cluster and what are diffrent counters (performance and other ) |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.