Built-In Performance Reports Location

Question

Post reply

Built-In Performance Reports Location

JWOL

Hall of Fame

Points: 3471
More actions
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.

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

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

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

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]

JWOL Hall of Fame Points: 3471 More actions · Answer 2

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

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

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

JWOL Hall of Fame Points: 3471 More actions · Answer 4

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

Jerry Hung SSChampion Points: 12968 More actions · Answer 5

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

Kendal Van Dyke SSCertifiable Points: 5972 More actions · Answer 6

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]

clement.ratel Old Hand Points: 319 More actions · Answer 7

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

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 8

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

MJ

clement.ratel Old Hand Points: 319 More actions · Answer 9

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=-

Built-In Performance Reports Location

Cookies on SQLServerCentral