Continuous Monitoring

Question

Continuous Monitoring

Prakash-205770

Ten Centuries

Points: 1079
More actions
January 10, 2008 at 8:27 am

#127500

Which is the best method to monitor sqlserver 2000 & sqlserver 2005 instances for the following ?
1.Availability of SQL Server Database Engine & SQL Server Agent
2.Space issues
3.Problems in Backup
4.Monitoring Mirroring
5.Cluster
6.Monitor Logshipping
7.Replication.
There are some restrictions such that we could not install any product in the client's server.
Regards,
R.Prakash
Kindest Regards,
R

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello Prakash,

You can monitor the required components in different ways. It would be very useful if you can initiate alerts sent to you for the components to be monitored. A third party tool like SQL Diagnostic Manager (I'm not marketing 🙂 ) will give a broader picture of what is happening on your SQL boxes. You can write your own SQL statements and make them as a job to insert data in to a base table which can later be queried upon to prepare reports etc. MOM also can be used but it should be configured properly.

Hope some peers here can answer in a more practical way.

This is the general idea I would like to present in a nut shell.

Hope this helps.

Thanks

Lucky

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

For some of your monitoring you can set SQL Mail to send you alert in jobs and for others you can find the SQL scripts to monitor it. Search in google for your respective scripts.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Karthik-214069 SSChasing Mays Points: 631 More actions · Answer 3

We used a tool called HP Open view in one of my previous companies...neat software and nearly monitors everything.

In my current company we use a tool called Argent for alerting

ChiragNS One Orange Chip Points: 26137 More actions · Answer 4

You can also use DMV's for getting the required information.

Check out BOL for more info on DMV.

"Keep Trying"

Paul Mu SSCertifiable Points: 5547 More actions · Answer 5

A company called IDERA has a SQL Monitoring product that will alert you to most of the issues you want to monitor in your list.

Paul

homebrew01 SSC Guru Points: 55548 More actions · Answer 6

We use Idera tools & like them. Also, the new version of WhatsUpGold can monitor all types of things on your server. We're using it quite extensively now. http://www.whatsupgold.com/

Ash73 SSC Veteran Points: 286 More actions · Answer 7

I noticed a couple folks mentioned Idera SQL Diagnostic Manager, so I will third their posts. We just began to use it so I'm trying to figure out how to solve some of the immediate critical alerts such as 'SQL Server Data used is 100%' and 'OS memory used is 100%'. This tool does an excellent job of identifying problems to a granular level, but I have a learning curve to get around figuring out how to resolve the issues.

Any advice from users of SQLdm would be appreciated...any online resources to use to research alerts? I haven't found any yet...

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 8

at the end of the day you're best off probably writing much of your own stuff. I will give a plug for diagnostic manager, which I use, but essentially you'll probably have less impact writing your own , tools such as openview, tivoli and such run multiple agents and drain resource , bmc patrol and tivoli are especially bad at paging and io.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/