How do get go about being able to view those performance reports on SQL Server 2005 Express Edition; you know, these things (with the charts and bar graphs):

alt text http://i46.tinypic.com/15hkfnk.jpg

  1. What are they called
  2. What do i have to install to access to them
  3. How do i access them?
  4. What are the SQL Server 2005 Performance Dashboard Reports
  5. How does #4 differ from #1
  6. When would one want to use #4 over #1

In SQL Server 2005 Somethingorother Edition, i right-click the server is "Enterprise Manager", select reports, and browse through them:

alt text http://i46.tinypic.com/23tk3s7.jpg

No such context menu option exists in SQL Server 2005 Express Edition.

Note: i try to ask the high-level question of "how to make it work", because the answer can, in turn, trigger a dozen or two other questions. (Microsoft's been good at keeping information about SQL Server secret in recent years)


As with the other question you asked about Profiler, the issue is you're using SQL Server Management Studio Express Edition, which is a pared down version of SQL Server Management Studio. The ability to run reports is available in the full version of SQL Server Management Studio (with SQL Server 2005 I believe you have to apply SP2 to the client tools). So you'll need to have a full version of SSMS, connect to the Express edition, and run the reports.

| improve this answer | |
  • And just to complete the answer: SSMS !Express Edition is not available for download? Also, the other question quotes Microsoft saying the Profiler is available; while saying nothing about these reports. – Ian Boyd Jul 3 '10 at 21:58
  • 1
    SQL Server Management Studio Express IS available for download: microsoft.com/downloads/… and the feature you're talking about is only available in the full version of SQL Server Management Studio which must be installed from the SQL Server CD (Standard/Enterprise/Developer/DataCenter, but not Express). These are standard reports provided by MS. However, you can write your own custom reports, hence the reason the menu context has Reports >> Standard or Custom Reports. – K. Brian Kelley Jul 4 '10 at 6:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.