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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 HP Openview Monitoring SQL Server

Author  Topic 

dbthj
Posting Yak Master

143 Posts

Posted - 2009-05-15 : 13:33:16
Our Monitoring Team (using HP Openview) is being pressed to monitor one of our many SQL instances. So they handed me the manual and said, "what do you want us to do?"

I thought they ought to get some hints from the vendor on what people typically did and how it was done. They said, "if you have a specific issue, we can open a ticket." I really don't want to read the manual from start to finish and invent myself a big old wheel.

If we implemented the "Standard Template" on a bunch of SQL instances, my pager would never let me sleep and my email would be flooded with useless messages.

Can someone offer some hints on basic guidelines or point me to some usefull doc?.... things that can tell the monitor to recognize the difference between a manual shutdown and an unexpected termination. That can tell the monitor the difference between a cluster failover and a clustered instance shutdown. And other pragmatic stuff.

   

- Advertisement -