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 Thursday, May 13, 2010 6:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 20, 2014 6:48 PM
Points: 1,136, Visits: 699
The dataset would also need the server name you are reporting on. That's an interesting modification. I'm not sure you'll be able to make both the report and the data source dynamic.
Post #921181
Posted Thursday, May 13, 2010 10:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:35 PM
Points: 525, Visits: 367
The interesting part is it works for all the other sub reports - this is the only one that is having a problem.
Post #921472
Posted Thursday, June 17, 2010 6:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 20, 2014 6:48 PM
Points: 1,136, Visits: 699
sibir1us (7/28/2009)
If you would like to use the Performance Dashboard 2005 on SQL Server 2008 you will have to make the following change in the usp_Main_GetSessionInfo stored procedure.

Change the line:

sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

to

sum(convert(bigint, CAST ( DATEDIFF ( minute, login_time, getdate()) AS BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute, DATEDIFF ( minute, login_time, getdate() ), login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,



I ran into to this problem, "Difference of two datetime columns caused overflow at runtime" on sql2005 today for the first time. Your code above worked....Thanks! I just wonder what changed to cause it to start happening....????
Post #938838
Posted Thursday, June 17, 2010 5:47 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:35 PM
Points: 525, Visits: 367
What changed is the number of days the system was up and that is what caused the issue.
Post #939311
Posted Friday, October 15, 2010 5:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:09 AM
Points: 1,046, Visits: 1,846
Nice read Robert. But I still find SSRS incometent to exploit the benefits of enterprise dashboarding.

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1005056
Posted Friday, December 3, 2010 12:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 7:53 AM
Points: 49, Visits: 850
Hi,

Nice article.

You can discover a lot more about DMVs in this forthcoming book www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

A simple monitor
Finding your slowest queries
Find your missing indexes
Identifying what SQL is running now
Quickly find a cached plan

Thanks
Ian
Post #1029675
Posted Friday, December 3, 2010 6:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 16, 2012 5:17 AM
Points: 11, Visits: 23
Good one!!
Post #1029807
Posted Friday, December 3, 2010 11:02 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Great Article!
I'd love to install the reports on a management server and have it email me the results from each of our servers, haven't quite started looking at how to programatically change the connection for each subscription. This way I coould have 1 set of RDL's that hit a different connection for each subscription.

Anyone have any thoughts?
Post #1030059
Posted Friday, December 3, 2010 12:49 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:35 PM
Points: 525, Visits: 367
Anyone know if there are performance dashboard reports available for SQL 2008 and SQL 2008R2?
Post #1030118
Posted Friday, December 3, 2010 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:35 AM
Points: 4, Visits: 20
After running the SETUP.SQL script, I'm getting the following errors:

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.

Any help would be spiffy.
Post #1030122
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse