<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
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 2 of 5
««
1
2
3
4
5
»
»»
SQL Server 2005 Performance Dashboard Using SSRS
Rate Topic
Display Mode
Topic Options
Author
Message
amc-885860
amc-885860
Posted Tuesday, July 28, 2009 11:53 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, April 08, 2013 5:14 PM
Points: 16,
Visits: 556
Thanks Bob! That was quick.
I re-traced my steps and as you just stated that's where I went wrong.
So I'm back on track now.
However, When I opened the "performance_dashboard_main.rd.",
I received this error in the Preview tab:
An error has occurred.....
Cannot read the next data row for the data set SESSION_CPU_WAIT_INFO.
Difference of two datetime colums caused overflow at runtime.
Please advise.
Post #760983
Rome-828069
Rome-828069
Posted Tuesday, July 28, 2009 12:08 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, December 01, 2009 7:50 AM
Points: 21,
Visits: 88
I am having the same problem as mcasner, any suggestions?
Post #760993
MattW2010
MattW2010
Posted Tuesday, July 28, 2009 12:56 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:21 AM
Points: 57,
Visits: 382
For 2008, should we use ms_ticks instead of cpu_ticks_in_ms from sys.dm_os_sys_info when creating procedure MS_PerfDashboard.usp_Main_GetCPUHistory?
Post #761029
Bob Griffin
Bob Griffin
Posted Tuesday, July 28, 2009 1:42 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 1,132,
Visits: 664
The Performance Dashboard was written for sql 2005. I have not ran on sql 2008, so I will have to defer the rest of the group...
Post #761070
mcasner
mcasner
Posted Tuesday, July 28, 2009 1:45 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, July 09, 2012 8:32 AM
Points: 6,
Visits: 41
I am running SQL Server 2005 and I'm still getting the error I mentioned.
Post #761074
MattW2010
MattW2010
Posted Tuesday, July 28, 2009 1:58 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:21 AM
Points: 57,
Visits: 382
I think I found the answer:
http://blogs.msdn.com/vascov/archive/2008/09/30/using-performance-dashboard-with-sql-server-2008.aspx
create procedure MS_PerfDashboard.usp_Main_GetCPUHistory
as
begin
declare @ts_now bigint
select @ts_now = ms_ticks from sys.dm_os_sys_info
Post #761086
comfortzone0
comfortzone0
Posted Tuesday, July 28, 2009 2:25 PM
Grasshopper
Group: General Forum Members
Last Login: Friday, April 29, 2011 10:28 AM
Points: 13,
Visits: 12
Hi, I ran into this error:
Could not find stored procedure msdb.MS_PerfDashboard.usp_CheckDependencies
Any suggestions?
Thank you.
Post #761104
MattW2010
MattW2010
Posted Tuesday, July 28, 2009 2:29 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:21 AM
Points: 57,
Visits: 382
I actually found a better solution to my issue (converting dashboard to 2008)
http://blogs.technet.com/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx
Post #761108
Bob Griffin
Bob Griffin
Posted Tuesday, July 28, 2009 5:56 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 1,132,
Visits: 664
nathan.holtrop (7/28/2009)
I am having the same problem as mcasner, any suggestions?
For the permissions problem, make sure you have select privilege on view server state...here's some info on that:
from:
http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx
To query a server scoped DMV, the database user must have SELECT privilege on VIEW SERVER STATE and for database scoped DMV, the user must have SELECT privilege on VIEW DATABASE STATE.
GRANT VIEW SERVER STATE to
GRANT VIEW DATABASE STATE to
Post #761207
Bob Griffin
Bob Griffin
Posted Tuesday, July 28, 2009 5:58 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 1,132,
Visits: 664
comfortzone0 (7/28/2009)
Hi, I ran into this error:
Could not find stored procedure msdb.MS_PerfDashboard.usp_CheckDependencies
Any suggestions?
Thank you.
Did you get any errors when you ran the sql script file...?
Post #761208
« Prev Topic
|
Next Topic »
48 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
