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:
- 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.