SQL SERVER – 2005 – Performance Dashboard Reports

The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later.

Common performance problems that the dashboard reports may help to resolve include:
– CPU bottlenecks (and what queries are consuming the most CPU)
– IO bottlenecks (and what queries are performing the most IO).
– Index recommendations generated by the query optimizer (missing indexes)
– Blocking
– Latch contention

The SQL Server 2005 Performance Dashboard Reports only use Dynamic Management Views and Catalog Views. They do not poll performance counters from the OS, nor do they store a history of your server’s performance over time. These are very light-weight reports that will help diagnose performance problems as they are occurring.

Download SQL Server 2005 Performance Dashboard Reports

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQL SERVER – 2005 – Performance Dashboard Reports

  1. Hi Pinal. So do you recommend using Performance Dashboard Reports then? How valuable do you find the index recommendations to be? How do they compare to the Index Wizard in SQL 2000? What is meant by latch contention?

  2. I do recommend to use Performance Dashboard reports. I have not used Index Tuning Wizard in SQL Server 2000 as they did not worked when Temp Table were used. In SQL Server 2005 it should work better as CTEs are introduced. I still have to use that for SQL Server 2005.

    Latches are mechanisms for prospecting internal shared data structures, such as lists of currently accessed tables, users accessing data etc. Processes acquire latches when manipulating these internal structures. Latch Contention determines how long a process will loop to try and get a busy latch before going to wait and trying later. In SQL Server latch could become a contention point when there were a high number of users using tempdb at the same time. Proportional fill has been optimized to eliminate this latch. With this change in SQL Server 2005, applications will experience less UP latch contention in tempdb.

  3. Pingback: Microsoft Blog Archives How do I monitor SQL Server performance?

  4. Hi,

    I am stuying about the Sql server 2005 Reporting services. I want to devlop a report like Dashboard system, if this is possible? or I have to download any tools to do this? Please help me.

  5. Hello, I have a column that contains a YYYYJJJ which is Year_Day of year type of julian date. How can I convert it to YYYYMMDD?

    Thank you.

    • Hi,

      Could you please check it below :

      DECLARE @JulianDate char(7) = ‘2013189’
      SELECT DATEADD(YEAR, @JulianDate / 1000 – 1900, @JulianDate % 1000 – 1)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s