July 28, 2009 at 1:58 pm
I think I found the answer:
create procedure MS_PerfDashboard.usp_Main_GetCPUHistory
as
begin
declare @ts_now bigint
select @ts_now = ms_ticks from sys.dm_os_sys_info
July 28, 2009 at 2:25 pm
Hi, I ran into this error:
Could not find stored procedure msdb.MS_PerfDashboard.usp_CheckDependencies
Any suggestions?
Thank you.
July 28, 2009 at 2:29 pm
I actually found a better solution to my issue (converting dashboard to 2008)
July 28, 2009 at 5:56 pm
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
July 28, 2009 at 5:58 pm
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...?
July 28, 2009 at 6:02 pm
amc (7/28/2009)
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.
Check out the first post of this discussion by sibir1us. I think that is the solution to what you are seeing.
July 29, 2009 at 5:53 am
I also had an issue with usp_Main_GetSessionInfo due to the max value for milliseconds in the DateDiff function being less than 24 Days (etc). Therefore, to maintain a good degree of accuracy still (and having had the problem before), I rewrote it like so :-
USE [msdb]
GO
ALTER PROCEDURE [MS_PerfDashboard].[usp_Main_GetSessionInfo]
AS
BEGIN
SELECT COUNT(*) AS num_sessions,
SUM(s.total_elapsed_time) AS total_elapsed_time,
SUM(s.cpu_time) AS cpu_time,
SUM(s.total_elapsed_time) - SUM(s.cpu_time) AS wait_time,
SUM(s.login_time) - SUM(s.total_elapsed_time) AS idle_connection_time,
cache_hit_ratio=(CASE WHEN SUM(s.logical_reads) > 0 THEN (SUM(s.logical_reads) - ISNULL(SUM(s.reads),0)) / CONVERT(FLOAT,SUM(s.logical_reads))
ELSE NULL END)
FROM (SELECT session_id,
CONVERT(BIGINT,total_elapsed_time) AS total_elapsed_time,
CONVERT(BIGINT,cpu_time) AS cpu_time,
CONVERT(BIGINT,DATEDIFF(ss,login_time,GETDATE()))*1000 AS login_time,
logical_reads, reads
FROM sys.dm_exec_sessions
WHERE is_user_process = 0x1
AND login_timeDATEADD(minute,-35791,GETDATE())) s
END
July 29, 2009 at 7:13 am
Bob Griffin (7/28/2009)
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
Just so others know...
GRANT VIEW SERVER STATE to
GRANT VIEW DATABASE STATE to
For these commands to work the user had to exist in the msdb db and the master db.
As well as
grant alter trace to
August 3, 2009 at 3:23 pm
While running the script ,me getting this error...need help
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.
Thanks in advance...Sam
August 4, 2009 at 6:18 am
Try the steps I listed in my posts.
August 4, 2009 at 3:17 pm
No luck still getting the same error..
August 25, 2009 at 2:06 pm
Thank you for the great article. It works for me if I ask it to prompt for login and I give my credentials. But if I use the service account that has sysadmin privileges I get an error like this:
An error has occurred during report processing.
Cannot impersonate user for data source 'DataSource1'.
Logon failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
Also if I use my credentials the authentication is not passed down to the smaller reports - it only works on main performance dashboard. Any suggestions much appreciated, thanks.
May 12, 2010 at 4:32 pm
Most of it works great published in SSRS and modified to allow the server name and instance name to manually entered except when I go into a sub, sub report. For example if I run the main performance dashboard report, then click on expensive queries by duration all is well. When I click on one of the queries returned by that sub report I get a screen that shows all of the prompts but does not return data. I went into BIDS and checked what the blank parameter was and found it was servername. If I fill that in I still receive an error message regarding a dataset. Any suggestions?
May 12, 2010 at 4:43 pm
I had a similar issue when trying to use windows integrated security. When I used credentials supplied by the user and checked the box for use as windows credentials when connecting to the data source I was able to run the reports. The user does have to enter their full domain\lanid and password but, it worked for me as long as there was a trust between the domains.
May 12, 2010 at 4:44 pm
Laura Grob (5/12/2010)
I had a similar issue when trying to use windows integrated security. When I used credentials supplied by the user and checked the box for use as windows credentials when connecting to the data source I was able to run the reports. The user does have to enter their full domain\lanid and password but, it worked for me as long as there was a trust between the domains.
Sorry this was in response to SSC Veteran's question
Viewing 15 posts - 16 through 30 (of 51 total)
You must be logged in to reply to this topic. Login to reply