SQL Performance Dashboard

SCOM would be what you're lookin for, but that's not free ;-)

http://www.microsoft.com/systemcenter/en/us/operations-manager.aspx

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.

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

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?

Get your Perfomance data into a SQL database and connect Excel to that, you can create your own dashboard.
Regards,
Walter

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 ......