Post reply

Built-In Performance Reports Location

  • December 11, 2008 at 4:57 am

    #196909

    Where are the built-in performance reports stored? I have searched the C drive of the SQL server for .rdl files but can't find any. I have also looked in c:\Program Files\Microsoft SQL Server\90\Tools. The reports I'm looking for are Scheduler Health, Memory Consumption, Server Dashboard etc.

  • December 11, 2008 at 6:01 am

    #910998

    You won't find them on your disk, but you can download them from here. You can read more about them here

    [font="Verdana"]Markus Bohse[/font]

  • December 11, 2008 at 7:00 am

    #911042

    Thanks for the link. So where does SQL Server store these report definitions?

  • December 13, 2008 at 4:32 pm

    #912113

    Its under the same directory where you installed performance dashboard reports. For me its under F drive performancedashboard folder.

    Or

    Search for performance_dashboard_main.rdl

    MJ

  • December 16, 2008 at 1:57 am

    #912990

    I searched for *.rdl files and none were returned.

  • December 16, 2008 at 8:22 am

    #913181

    I'm using SSMS 2008, it came with a lot of Standard Reports

    but if I try to open Custom Report, it looks under "My Documents"

    but I am shocked search for *.rdl didn't find anything?

    I would've guessed C:\Program Files\Microsoft SQL Server\90 as well

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • December 16, 2008 at 8:30 am

    #913187

    As MarkusB indicated, the built-in reports (which you were originally asking about) are not stored on disk; Manu was referring to the performance dashboard reports which are a seperate download available here.

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • February 18, 2009 at 2:27 am

    #945737

    Hi,

    I have a near question.

    I'm searching for Scheduler Health 's rdl.

    Does somebody knows where I can find Scheduler Health 's report ?

    Because it displays a truncation error and I would like to correct it.

    It is not part of the 20 Performance Dashboard Reports rdl.

    a+, =)

    -=Clement=-

    Configuration :

    bids 2005

  • February 18, 2009 at 7:46 am

    #945929

    I don't think this report is a part of standard reports.

    MJ

  • February 18, 2009 at 7:59 am

    #945945

    Hi,

    thank you for your answer.

    As the report displayed normally since (without doing more than many refresh), I have not this need anymore.

    a+, =)

    -=Clement=-

Viewing 10 posts - 1 through 9 (of 9 total)

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