Does anyone have a link to SSRS versions of the performance dashboard reports. or is it as simple as publishing the rdls to your rs server and providing a shared Data Source to msdb ?

I know its questionable why this would be required  but ...

Do you want to create custom reports into Performance Dashboard reports?

I don't think the Performance Dashboard reports are design to be called from Reporting Services.  They are built to be rendered in SSMS.   You can download the rdl file for the Performance Dashboard here:  

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

I have also developed a SQL Server DBA Dashboard tool that has a bunch of additional reports. You can download my dashboard here:

http://sqlserverexamples.com

But if you deploy those RDLs files into RS server, you can setup a subscription to the performance dashboard main.rdl file and can get a snapshot of the server performance at regular intervals over email.

Thats what i did in my production, and it works great..It also gives us a chance to view the peak time usages on a consistent basis..

thks,

Mani

MCDBA,MCTS

Usually you dont need to make any changes but just adding the shared datasource for your sql server. But you can customize the main report with your servername, instance name, etc.. Adding anyother report items like the time, username, etc..

thks,

Mani

So have you figured out how to make it work for different servers from a single SSRS web portal?

not yet. Becuase if we want to use for multiple servers, we can use SSMS custom reports option..But i got another idea. Do you think we can make it work by adding a additional parameterized report that takes the servername and the report can dynamically change its datasource??

thks,

Mani 

hmmmm...i think its possible... was doing some lil googling...i got few links...

http://nickbarclay.blogspot.com/2005/10/ssrs-dynamic-connection-strings_04.html

this might work..i'l try and let you know.

thks,

Mani

This would be extremely helpful in order to allow these to be used to monitor multiple instances from a central SSRS location.  Has anyone gotten this to work yet?

I am already doing this.  I have a website set up and a select page that pulls from a list of our servers in a central location.  That page has hyper links to each server/database and passes that to the main page (DBA Dashboard_main).  It would pass the database name and server name along.  I had to use his install script on each server that I wanted to pull data from.  Then I would use a common login that has execute permission.  I would then use that common login for the data source for each page.  The query for each dataset for each page would have to be changed to the following:

 exec (@InstallDB + '.[DBA_Dashboard].Get_IndexFrag ''' + @DatabaseName + '''')

or

exec (@InstallDB + '.[DBA_Dashboard].Get_TablesWithoutPKs ''' + @DatabaseName + '''')

depending on what data source you want to use.  I would like to write an article about this in SQL magazine with Gregs permission and help (and with credit to him of course).  What do you say Greg?

 Just a quick update:  I am working with Greg to get this done.  Either changes to his existing product or just an article.

nevermind