i have a problem when i click on any blue region in the chart for the SQL CPU utilization on the performance dashboard where you normally would get further infos (reports for the last 15 minutes).
There comes no report but a side with "Error: Arithmetic overflow error converting expression to data type datetime."
This happens on two different servers with SQL Server 2005 Enterprise Editions, but all other drill through is functioning. What' s the problem, is it a problem in recent_cpu.rdl or performance_dashboard_main.rdl or in the called stored procedures. Please help, it is a really good tool, but i cannot use it.
Thanks for help
HeinrichSee this http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx?CommentPosted=true blog.|||Hi,
i know the link, i have posted the problem there also (see Heinrich).
But the changing of the setup.sql as described there doesn't help.
I get the failure as before. No SQL Server is functioning at the described point when i want to get detail information on pointing on the blue sql parts in the System CPU Utilization.
I am not a sql programmer, so i am not able to find the probleme, so i cannot use this Performance Dashboard.
Thanks for further help.
Heinrich
No comments:
Post a Comment