SQL Server 2005 Performance Dashboard Using SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Robert Griffin » SQL Server 2005 Performance Dashboard Using...

48 posts, Page 5 of 5

«««1 2 3 4 5

SQL Server 2005 Performance Dashboard Using SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

Laura Grob

Posted Friday, December 03, 2010 1:17 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:31 PM
Points: 525, Visits: 241

Are you running the script on the MSDB in a SQL 2005 instance that is SP2 or higher?

Post #1030126

TalkSql

Posted Friday, December 03, 2010 2:46 PM

Grasshopper

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

medwards-789575

Posted Friday, December 03, 2010 4:20 PM

Forum 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

TalkSql

Posted Friday, December 03, 2010 4:44 PM

Grasshopper

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

medwards-789575

Posted Friday, December 03, 2010 4:50 PM

Forum 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

TalkSql

Posted Friday, December 03, 2010 5:13 PM

Grasshopper

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

medwards-789575

Posted Friday, December 03, 2010 5:17 PM

Forum 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

TalkSql

Posted Friday, December 03, 2010 5:43 PM

Grasshopper

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

« Prev Topic | Next Topic »

48 posts, Page 5 of 5

«««1 2 3 4 5

Permissions