Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-06-11 : 14:07:01
|
| Guys, has anyone tried using this free Microsoft Performance Dashboard tool that can be downloaded from this link?http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=enI am having problem to preview it. Basically, my environment is this:1. I have a databse server. This is where I download everything and run the setup.sql and I could see all the stored procs in my MSDB.2. My reporting server is in a different box( but it gains the info and data from the database server). This is where I open the Visual Studio and then open up the SSRS and run my report. I am trying to preview the report, but I am getting this 'query execution failed for dataset 'CHECK_DEPENDENCIES'. Could not find stored procedure msdb.MSPerfDashboard.usp_Check_Dependencies'I am able to see the report when I browse it on my web browser. But when I click any of those report there, the same error comes back. Some please help me. I am trying to use this useful tool. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-11 : 22:30:32
|
| You don't need RS to run them, just right click server in ssms and choose reports -> custom reports -> go to performancedashboard folder -> run performance_dashboard_main.rdl. |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-06-12 : 13:46:37
|
| Wow.Indeed!Also let me share the problem that I have solved from the question that I had. I had an instance and was not pointing it at the instance previously. Thats why it failed. Now that I have pointed it to the right instance, the report worked like a champ.Thanks for your idea of running the report from Management StudioBut, I have one question though, how do you specify the target URL from management Studio? Isn't it has to be done from Visual Studio(SSRS)? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 00:20:58
|
| Don't need url if you install that pack in sql. |
|
|
|
|
|
|
Performance Dashboard