MOM for SQL monitoring

Question

MOM for SQL monitoring

mssql_rules

SSCrazy

Points: 2783
More actions
March 17, 2004 at 12:28 pm

#82470

Has any one used Microsoft Operations Manager (MOM) to monitor SQL Server? We have about 30 SQL Servers, with no monitoring solution. We are looking into MOM since that has been recommended for monitoring Exchange and the DBA team has been asked to evaluate if the same can be used for SQL Servers too. If any one has already used it, I would like to get your feedback. In essence, I need to do some basic SQL monitoring like, read sql errorlogs, check failed jobs, database space monitoring and check that all dbs are online etc.
Thanks.

Viewing 11 posts - 1 through 10 (of 10 total)

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

RSP SSCrazy Points: 2614 More actions · Answer 1

Hello,

Have you checked out SQLCentric? It is a web-based MSSQL-Centric network database monitoring and alert system, that captures all the information that you are looking for. The price entry point may also be more desirable!

The system is deployed on your company’s corporate intranet. SQLCentric is extremely easy to install, deploy, manage and use. No complex configuration Minimally invasive to the SQL Servers it monitors, no agents installed, and is a zero-impact solution.

The vital signs of each server are monitored for disk space, server uptime, ping connectivity, SQL Server, SQLAgent and Database status, as well as Job Failures. The user is notified via email/pager for any of these conditions. When new servers are added, ping connectivity reestablished, SQL Server, SQLAgent, and OS comes on-line, an alert will also be generated. Clustered Servers supported.

Integrates with your e-mail system to provide auto-alerts and follow-up messaging. An intuitive administration module allows the user to manage servers, groups, & email operators, configure run-time parameters and disk alert thresholds.

Hope this helps!

philcart SSC-Forever Points: 47795 More actions · Answer 2

We implemented Servers Alive <http://www.woodstone.nu/salive>

Good all-round monitoring and alerting for all servers/apps. Easy to install and setup.

Price is good as well.

--------------------
Colt 45 - the original point and click interface

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 3

We have MOM here. THe backend database server that collects the data from all of the windows servers is very busy but we have about 200 servers though. I utilize the e-mail option which when a SQL Server job fails the event log entry is seen by MOM and I get an e-mail altering me that a job has failed.

Rudy Panigas SSChampion Points: 10702 More actions · Answer 4

I'm currently using SQL SpotLight by Quest. (http://www.quest.com/spotlight_sql/) It works great and also has a very nice GUI front end to it too.

Rudy

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 5

We are using MOM for our 100+ servers.

For me it was a good solution. Every time I need to be notified by any process, and just save the message, or error to Event Viewer and create a rule in MOM.

The MOM agent will ony send the notificacion once it found any error that matches a rule in event viewer.

And also, by using logevent.exe I also can save messages in event viewer to be notified by some command lines programs.

mssql_rules SSCrazy Points: 2783 More actions · Answer 6

Thank you every one for your feedback and those using MOM please post any gotchas. I used sitescope in the past and found that to be fairly easy to setup and use. However, at my current place MOM has already been chosen for other stuff (like exchange monitoring) and unless I hear of anyone 'got burned' with this tool monitoring SQL servers, I am going to use the same for SQL monitoring. It is not that the tools you guys have recommended do not work, but just it would be too much for me to evaluate these tools and more important get mgmt buyout. It has taken me over a year to convince the bosses that a DBA cannot manage 35 SQL servers without a monitoring tool.

thanks.

philcart SSC-Forever Points: 47795 More actions · Answer 7

When we where evaluating MOM, the only gotcha we found was the price. Especially when you pay extra to add application level monitoring.

--------------------
Colt 45 - the original point and click interface

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 8

Not to trash MOM but we monitor all of about 200+ servers, and the repository server is bogged down with the influx of data and our db was 29 gig. So, if you are monitoring over 100 servers be prepared to have a beefy server. Ours is a dual 750mz with 2 gig of memory. The latest release fixed a lot of bugs that were annoying.

Antares686 SSC Guru Points: 125444 More actions · Answer 9

MOM worked well for us but did have a few issues with network traffic on it which was solved by adjusting some of the things it monitored. Ultimately though we dropped it because we needed the box it was on for another project, but all in all it did well.

Wesley Brown SSChampion Points: 12045 More actions · Answer 10

We monitor around 100 servers here and found out the hard way that some IIS events fire every second or so and MOM will trap them. Our database got around 80 gig and 95% of it was IIS info messages. Other than that it works pretty well. I only have mom grab perf counters to alert on and to check to see if all the services are running but we will move all alerts over to it for SQL in time.

Wes