SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Performance Dashboard Using SSRS


SQL Server 2005 Performance Dashboard Using SSRS

Author
Message
Laura Grob
Laura Grob
SSChasing Mays
SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)

Group: General Forum Members
Points: 658 Visits: 480
Are you running the script on the MSDB in a SQL 2005 instance that is SP2 or higher?
TalkSql
TalkSql
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 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.
medwards-789575
medwards-789575
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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.
TalkSql
TalkSql
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 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
medwards-789575
medwards-789575
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 20
Bala, I'm sorry, I forgot to mention that I'm running 2005 SP2.
TalkSql
TalkSql
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 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.
medwards-789575
medwards-789575
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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?
TalkSql
TalkSql
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 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
kvon11-961712
kvon11-961712
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 109
Check your data source and that permission are applied
rajasekhar.bollareddy
rajasekhar.bollareddy
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 116
Sir,

This will give 24 hours history of CPU?

Thanks,
Raj
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search