Post reply

Performance Dashboard - DataSources

  • 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

  • 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

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

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