SQL Server Performance

SQL Monitoring Tool

Discussion in 'Analysis Services/Data Warehousing' started by tusharkhulage, Nov 16, 2006.

  1. tusharkhulage New Member

    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 />
  2. hjyoungii New Member

    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.
  3. jezemine New Member

    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

Share This Page