Sunday, February 12, 2012

Cannot run Performance Dashboard on SQL Server 2005

All,

I running SQL Server 2005 on a 64-Bit build and getting the error " difference of two datetime cause overflow at runtime" when I try the open the Performance_Dashboard_Main .

Regards

Akin

Refer http://www.sql-server-performance.com/bm_performance_dashboard_2005.asp

Where to Get the SQL Server 2005 Performance Dashboard?

In order to install the SQL Server 2005 Dashboard, you must download at least two files from Microsoft. First, if you have not done so already, you must download SQL Server 2005 Service Pack 2. This is because Service Pack 2 includes new functionality that has been added to support the Performance Dashboard.

You can download SQL Server 2005 Service Pack 2 from:

www.microsoft.com/technet/prodtechnol/sql/2005/downloads

You can download the SQL Server 2005 Performance Dashboard add-on from:

www.microsoft.com/downloads

Madhu

|||

Both performance Dashboard and SP2 have been installed on the server the problem is opening the Performance_Dashboard_main.RDL gives an error message "Difference of two datetime columns caused overflow at runtime"

|||

It's a known issue when a login has been logged in for a long duration, you get the overflow error. You can find the fix for the error in this thread - read the very last post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1747720&SiteID=1

-Sue

No comments:

Post a Comment