Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

closed as off-topic by TomTom, mdpc, DKNUCKLES, Rex, Nathan C Jun 3 at 13:22

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they tend to become obsolete quickly. Instead, describe your situation and the specific problem you're trying to solve." – TomTom, mdpc, DKNUCKLES, Rex, Nathan C
If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

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.

share|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
add comment

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

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