• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

SQL Performance Dashboard

Is there a way to centralize the performance reports that can be run from SSMS? I have them installed on every server  and export to excel but was wondering if there was an easier/quicker way.
0
Robert Timmons
Asked:
Robert Timmons
1 Solution
 
Kobe_LenjouCommented:
SCOM would be what you're lookin for, but that's not free ;-)

http://www.microsoft.com/systemcenter/en/us/operations-manager.aspx
0
 
Umesh_MadapCommented:
I dont think we can centralis all the SQL Performance Dashboard ..... just i would like to know exactly what information you want to gather ...

you can alos use the PAL (performance analyis log) tool and you can automate and manage cetralizly.

0
 
wwwallyCommented:
Here is a new SQL perfomance moniotring/troubleshooting dashboard.
http://savision.com/products/vital-signs/sqlserver#product-product
They make some good stuff for SCOM (monitoring) so if you can take a test drive.
Regards,
Walter
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Robert TimmonsSenior Technical ConsultantAuthor Commented:
I am basically after some of the wait stats that I can corrolate to perfmon stats. Sounds easy right, well we have already done performance/scalability testing for them twice and when I say we I mean my company and two seperate partners that both specialize in those two things. But it seems they cannot understand the reports or just want more. I am trying to give them simple tools they can use to prove to themselves what we are trying to explain to them.

I have to use existing software in the environment. The guys that do the network monitoring will not allow any type of additional software installed.....period end of story.

So I figure between the canned SQL dashboard reports and PERFMON reports and maybe with some excel thrown if for good measure I can show them the path!

Let's see what I come up with this weekend or does anyone have any more ideas?
0
 
wwwallyCommented:
Get your Perfomance data into a SQL database and connect Excel to that, you can create your own dashboard.
Regards,
Walter
0
 
Robert TimmonsSenior Technical ConsultantAuthor Commented:
Once I saw that the reports were just rdl files. I started looking SSRS and think the info from the below link will work for now. I am testing right now and will let you know how it goes.

http://blogs.technet.com/b/rob/archive/2010/09/28/hosting-the-performance-dashboard-reports-in-ssrs.aspx

0
 
Robert TimmonsSenior Technical ConsultantAuthor Commented:
The link I posted gave me enough info to complete the project for now. I was able to combine dashboard reports across multiple SQL 2005 x64 Enterprise instances. But once I reviewed the raw wait stat data I knew SQL server was not the bottleneck but needed pretty graphs for the ......
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now