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 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2005-11-29 : 12:12:17
|
| I've currently got some customised scripts checking for free hard disk space and SQL Error Logs on 5 servers (2 servers are in house, the other 3 are sitting on clients sites). These scripts run from 1 server , every hour as a job and send email alerts if relevant.recently, there has been a necessity to monitor mor info , such as ping. Overall, is it more flexible/effectice to keep developing on a custom level, or are there monitoring tools which you might recommend , thatwould save work - but are free or at least v.cheap. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-29 : 15:12:19
|
| We use NetIQ, MS MOM, custom scripts, HP Insight Manager, and various other monitoring tools. None of them are cheap, even the custom scripts if you take into account how much time it takes to write them.Tara Kizeraka tduggan |
 |
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2005-11-30 : 09:49:12
|
| We use monitoring tools from HP and Quest. I'd recommend checking out Nagios. It's open source and allows you to monitor just about every windows/sql performance counter. |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-11-30 : 10:56:22
|
| I've heard good things of late about Idera's monitoring. It's relatively cheap. We use BMC Patrol at my current customer, but I've used Quest and Embarcadero also. All do fairly well at the basics. Like Tara mentions, custom scripts will likely be a part of any solution you implement. No product does everything out of the box, especially some of the deeper SQL stuff (e.g. wait types, virtual file stats, blocking, fragmentation). But if you are looking for disk space remaining, db size, uptime, etc., most products will get the job done.I also like Tara's comment about cost. Developing custom can be a hard-dollar savings, but it's still time you are spending not solving business problems. You will have to weigh the soft-dollar cost there. I'm not saying don't write the custom scripts, but maybe buy the basics and supplement where they fall short.Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
lausser
Starting Member
1 Post |
Posted - 2009-05-27 : 15:15:46
|
| Hi,i wrote a plugin for Nagios, which checks a lot of SQL Server metrics.You can download it at http://www.consol.de/opensource/nagios/check-mssql-health/Prerequisites are perl and the module DBD::Sybase.Sorry, the documentation on the website is german only, but i hope you get the idea from looking at the examples. (Later this year, when i'll get more spare time, i'll translate it into english. What you can check with the plugin- free space in a database- transactions/sec- full table scans/sec- latch waits- time to connect- connected users...Gerhard |
|
|
|
|
|
|
|
|
Monitoring tools