Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

SQL Server 2005 Performance Dashboard Using SSRS Expand / Collapse
Author
Message
Posted Friday, December 3, 2010 1:17 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:26 AM
Points: 525, Visits: 325
Are you running the script on the MSDB in a SQL 2005 instance that is SP2 or higher?
Post #1030126
Posted Friday, December 3, 2010 2:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 27, 2011 9:58 PM
Points: 15, Visits: 79
Matt,

I had the same error too, after spending few mins in Google I found this article which solved the issue. Hope this helps.

http://sqlblogcasts.com/blogs/neilhambly/archive/2010/08/27/sql-2005-reports-using-the-dmv-dm-os-sys-info-tweaks-for-2008.aspx

Let me know if this solved your problem

Best,
Bala.
Post #1030167
Posted Friday, December 3, 2010 4:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:35 AM
Points: 4, Visits: 20
I did run it against the MSDB just to be sure and it gave the same error.

Bala, I looked at the link you posted and it did not help.

Post #1030192
Posted Friday, December 3, 2010 4:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 27, 2011 9:58 PM
Points: 15, Visits: 79
OK, I am not sure about your error, but assuming that this might be error you are getting..

Msg 207, Level 16, State 1, Procedure usp_Main_GetCPUHistory, Line 6
Invalid column name 'cpu_ticks_in_ms'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_Main_GetCPUHistory', because it does not exist or you do not have permission.

So, try this post which asks us to change the directory for the "Performance Dashboard "

[Download and install the performance dashboard reports as normal (but save the files in the Program Files\Microsoft SQL Server\100\Tools\PerformanceDashboard directory) and then modify the setup.sql file as shown below before running it against your SQL Server 2008 instance.]

http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx


Once you are done with this, then come back check this post.

Then also again go back to this post where you have to change a SP "MS_PerfDashboard.usp_Main_GetCPUHistory" If you are using SQL Server 2008.

[url=http://sqlblogcasts.com/blogs/neilhambly/archive/2010/08/27/sql-2005-reports-using-the-dmv-dm-os-sys-info-tweaks-for-2008.aspx][/url]

This is how i made it work, Hope this will work for you too. Let me know.

BEST,
Bala
Post #1030203
Posted Friday, December 3, 2010 4:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:35 AM
Points: 4, Visits: 20
Bala, I'm sorry, I forgot to mention that I'm running 2005 SP2.
Post #1030204
Posted Friday, December 3, 2010 5:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 27, 2011 9:58 PM
Points: 15, Visits: 79
Then, there shouldn't be any changes to the code. Those post of mine are only for SQL Server 2008 I don't have SQL Server 2005 to test the code. Sorry my posts weren't not in much help to you.

btw, what's the error you get ?

Good Luck,
Bala.
Post #1030209
Posted Friday, December 3, 2010 5:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:35 AM
Points: 4, Visits: 20
Thanks, Bala. The Error that I'm getting is as follows:

Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist or you do not have permission.


The first error seems to infer that I don't have SP2 installed... which I do have installed.

Do you think that reapplying SP2 might fix this issue?
Post #1030210
Posted Friday, December 3, 2010 5:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 27, 2011 9:58 PM
Points: 15, Visits: 79
You are right. try to run the sp2 upgrade. This post answers your question.

[url=http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic23583.aspx][/url]

update.

Best,
Bala
Post #1030214
Posted Wednesday, August 7, 2013 6:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2014 11:51 AM
Points: 1, Visits: 109
Check your data source and that permission are applied
Post #1482110
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse