Is there any software (preferbly open source) similar to these products:
I have looked at zenoss with MSSQL server pluggins but it is more geared to OS monitoring rather than specific to MSSQL performance monitoring.
Answer by sp_lock ·
There are a number of this take you can do with the dashboard reports if your wanting a free option.
I use Idera which imo is one of the best (sorry Melvyn).
Answer by Håkan Winther ·
I have been using "Precise for databases" from www.precise.com (former Veritas I3), and it is a very nice monitoring and tuning product. It gives a dashboard with resource consumption statistics and alerts you when abnormal behaviour occurs. You can also get recommendations on how to and what to tune in your database
Answer by Grant Fritchey ·
If you're looking for free, just go to work on PerfMon, the DMV's, and server-side traces. You can gather all the information you need from exactly the same sources as used by these other tools. Assuming you're not managing hundreds of servers, setting this up shouldn't be too difficult. If you are managing hundreds of servers, you really should get a third party tool.
That said, I love the Idera product and think it's worth the cost. I also use Microsofts System Center Operations Manager. It's very good for collecting performance metrics (not so hot for reporting on them though).