up vote 0 down vote favorite
1
share [g+] share [fb]

I am looking for some open source software which I can use to monitor Microsoft SQL server 2005 & 2008.

The features that I would like include:

  • Graphing
  • Recording of CPU usage
  • Recording of Disk I/O stats
  • Be able to setup notifications when a counter passes a threshold

I would also if possible like to incorporate some SQL server specific metrics like buffer cache hits, number of sessions etc...

Can anyone make any recomendations as to what you use in your environment.

link|improve this question
feedback

3 Answers

up vote 2 down vote accepted

If you're looking for something cheap and quick (which it doesn't sound like, but just in case), try MRTG.

If you'd like an actual NICE graphing solution, I'd recommend Zenoss (they have a free and a commercial version) or Cacti, which is free.

Both of these have great interfaces, pretty graphs, and send alerts based on thresholds.

link|improve this answer
Zenoss looks like a good solution and combined with the SQL Server Zen packs it should give me what I need. Thanks – AdamW Sep 27 '09 at 13:39
feedback
up vote 0 down vote

We use SCOM but that's probably more than you need, although it is the ultimate (we use it to monitor more than 100,000 servers). Nagios is a popular bit of monitoring software that is open source.

link|improve this answer
feedback
up vote 0 down vote

You can also use Zabbix and get SQL Server specific information with Performance Counters.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.