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 Tuesday, July 28, 2009 11:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 19, 2013 11:53 AM
Points: 17, Visits: 559
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
Posted Tuesday, July 28, 2009 12:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 1, 2009 7:50 AM
Points: 21, Visits: 88
I am having the same problem as mcasner, any suggestions?
Post #760993
Posted Tuesday, July 28, 2009 12:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 21, 2014 6:29 PM
Points: 58, Visits: 398
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
Posted Tuesday, July 28, 2009 1:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:01 AM
Points: 1,136, Visits: 697
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
Posted Tuesday, July 28, 2009 1:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 1:34 PM
Points: 6, Visits: 49
I am running SQL Server 2005 and I'm still getting the error I mentioned.
Post #761074
Posted Tuesday, July 28, 2009 1:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 21, 2014 6:29 PM
Points: 58, Visits: 398
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
Posted Tuesday, July 28, 2009 2:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 28, 2014 11:39 AM
Points: 15, Visits: 16
Hi, I ran into this error:

Could not find stored procedure msdb.MS_PerfDashboard.usp_CheckDependencies

Any suggestions?

Thank you.
Post #761104
Posted Tuesday, July 28, 2009 2:29 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 21, 2014 6:29 PM
Points: 58, Visits: 398
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
Posted Tuesday, July 28, 2009 5:56 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:01 AM
Points: 1,136, Visits: 697
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
Posted Tuesday, July 28, 2009 5:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:01 AM
Points: 1,136, Visits: 697
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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse