SQL Monitoring Tool | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Monitoring Tool

Please can anybody know any <b>SQL Monitoring Tool</b> which will take of <br /><br /><br />- Capacity Planning(Disk Space, CPU Usage, Memory Management) <br />- Troubleshooting SQL Servers( those who are more then 100 GB DB) <br />- Load Testing(Performance issues) <br />- Reporting Tools <br />- Slow Running Queries <br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />] <b>Thnks a Lot in Advance</b> [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />-Tushar<br /><br />(there are 2 things in life that hurts more than death.when u r love loves u & don’t tell u; and u r love doesn’t love u and tells u .) <br /><br /><br /><br />
Have you checked out Embarcadero? Their site is www.embarcadero.com. It is one of the leaders out there. I personally use it and love all the things it has to offer.
if you have SSMS installed, you can take a look at the reports in it. many of them have this information. if you don’t have it, you can get the reports for yourself here:
http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx SqlSpec – a fast, cheap, and comprehensive data dictionary generator
for SQL Server 2000 and 2005 and Analysis Server 2005 – www.elsasoft.org