Performance Dashboard For Many Servers

Question

Post reply

Performance Dashboard For Many Servers

Lookup_BI

SSCrazy

Points: 2964
More actions
August 25, 2009 at 8:52 am

#138326

Hi,
I have 1 SQL Server 2008 Enterprise Edition that would be hosting the reports for the preformance dashboard of all other Production Servers [SQL 2000 & 2005 Enterprise Edition].
I have downloaded SQL Server 2005 Performance Dashboard from the following http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en .
Must I run the setup.sql on each SQL Server 2000 @ 2005 edition that is to be monitored for performance dashboard ?
Do I also need to execute the setup.sql on the SQL Server 2008 as well?
What would be the next step,as my idea is to be able to view Performance Dashboard Reports for all Production Servers on the SQL Server 2008 Reporting Site?
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jason Crider SSCertifiable Points: 6019 More actions · Answer 1

hopefully http://www.sql-server-performance.com/articles/per/bm_performance_dashboard_2005_p1.aspx will get you going.

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter

Lookup_BI SSCrazy Points: 2964 More actions · Answer 2

Thanks, I shall go through it.

[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

Michael Tocik SSCertifiable Points: 7039 More actions · Answer 3

Hi

I came across this which we currently use.

http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx

Something extra you may want to look at

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Michael Tocik (8/27/2009)
Hi
I came across this which we currently use.
http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx
Something extra you may want to look at

Nice find.

A note about this dashboard is that it requires SQL 2k5 sp2. Not sure how it will interact with the SQL 2K instances mentioned in the post.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Darwin101 SSC-Addicted Points: 400 More actions · Answer 5

That is a nice report (dba dashboard), but the stored procs are locked so that you can not see the code that makes up the report :sick: