SQL Server 2005 Performance Dashboard Using SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

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 1 of 5

1 2 3 4 5 »»»

SQL Server 2005 Performance Dashboard Using SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

Bob Griffin

Posted Tuesday, July 28, 2009 12:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:26 PM
Points: 1,132, Visits: 663

Comments posted to this topic are about the item SQL Server 2005 Performance Dashboard Using SSRS

Post #760534

sibir1us

Posted Tuesday, July 28, 2009 6:05 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 24, 2013 12:47 PM
Points: 21, Visits: 291

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,

Make everything as simple as possible, but not simpler.
Albert Einstein

Post #760689

timblackwell

Posted Tuesday, July 28, 2009 7:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 18, 2013 10:45 AM
Points: 1, Visits: 76

found I had to to this to get it to work in 2005 otherwise got an overflow error when calcing the difference between 2 datetimes.

Post #760745

Bob Griffin

Posted Tuesday, July 28, 2009 8:00 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:26 PM
Points: 1,132, Visits: 663

I haven't ran into either of those problems yet. Thanks for the tips though!

Post #760768

MattW2010

Posted Tuesday, July 28, 2009 9:01 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:21 AM
Points: 57, Visits: 382

When running the statement for GetCPUHistory for 2008, it is telling me that "cpu_ticks_in_ms" is an invalid column for sys.dm_os_sys_info. Can you please advise? Thanks - Matt

Post #760834

MattW2010

Posted Tuesday, July 28, 2009 9:06 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:21 AM
Points: 57, Visits: 382

Also, after running the Performace_Dashboard_Main.rdl for 2008 (which worked), I had to manually insert the default values for every version string parameter. Should the parameter that defaults for the Main report be the same for the rest of them?

Lastly, what sort of values would I use in order for the report to appear for the query_plan.rdl report?

Thanks again,
Matt

Post #760837

SanjayAttray

Posted Tuesday, July 28, 2009 9:39 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Thanks for article Bob. We use three different third party tools to monitor same stuff but good to have all in one place.

SQL DBA.

Post #760879

amc-885860

Posted Tuesday, July 28, 2009 11:16 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 08, 2013 5:14 PM
Points: 16, Visits: 556

Hi, I'm a new dba trainee.
I'm not finding the 'reports' folder after I created a new solution project "Performance Dashboard" in the Solutions Explorer.
Did I miss a step? Anyone?

Post #760960

mcasner

Posted Tuesday, July 28, 2009 11:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 09, 2012 8:32 AM
Points: 6, Visits: 41

I followed the steps in this post and everything seems to work. However, I get an error "query execution failed for data set "CPU_UTILIZATION_HISTORY" User does not have permission to perform this action.

I thought that the grant statements in the setup.sql would have taken care of this.

Anyone have any suggestions?

Post #760975

Bob Griffin

Posted Tuesday, July 28, 2009 11:39 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:26 PM
Points: 1,132, Visits: 663

AMC,
Just make sure your created it as a "report server project" on the opening "create project" screen and the folder should be there.

Post #760976

« Prev Topic | Next Topic »

48 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions