Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jspatz
Starting Member
15 Posts |
 Posted - 2009-06-16 : 11:04:53
|
| I am curious to know how other organizations monitor their Clustered SQL 2005 Instances. I have been browsing the web and most articles that talk about monitoring performance only deal with Single Instance Servers when putting together counters in perfmon. We are using MS Clustering and have 6-7 instances housing about 20-30 lightly used DBs and about 5 moderately used db's. We are waiting on funding for a third party monitoring solution (which unfortunately takes forever and a day) but I was curious in the interim if there is a good and "neat" way of keeping track of Memory Usage, CPU, Buffer Waits etc, based on instance and DB, and if anyone would be willing to share. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-16 : 12:16:47
|
| Just monitor the virtual SQL Server name. The counters usually pick up after a failover. As for which instances are eating the most CPU over a period of time, you would have to isolate one, and monitor CPU usage on that one box. |
 |
|
|
|
|
|
Monitoring Performance in a Clustered Environment