Performance Dashboard - DataSources

• The Wisenut

  Right there with Babe

  Points: 756

  More actions

  February 20, 2008 at 10:39 am

  #186840

  Hi,

  Any idea where exactly the datasources reside that is being used by the performance dashboard reports. I was thinking to reuse the same and make some modifications so that i could use them at the database level rather than the server level. I know it gets the data from the DMVs and DMFs. But is there any procs that does it..

  It would save me a lot of time rather than creating them from scratch

  Thanks

  Vinoj

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  February 20, 2008 at 11:32 am

  #780330

  You can create a new SSRS project and add the existing RDL files (i.e. C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard). You can then extract the DDL/DML used to produce the reports from the data tab in VS/BIDS.

  Tommy

  Follow @sqlscribe

• The Wisenut

  Right there with Babe

  Points: 756

  More actions

  February 20, 2008 at 12:12 pm

  #780345

  Well thats exactly what I tried but, when i take the data tab, it gives an error. DataSource1 not found... Any idea where this is located

• The Wisenut

  Right there with Babe

  Points: 756

  More actions

  February 20, 2008 at 12:29 pm

  #780353

  Thanks for the help. I managed to figure it out. The datasources are built when the setup.sql is run present in the C:\Program Files\Microsoft SQL Server\90\Tools\PerformanceDashboard folder. This creates a schema with the name MS_PerfDashboard within the msdb database. Couple of procs and functions that help in the generation of the report

  Vinoj