Post reply

Performance Dashboard

  • August 2, 2011 at 7:02 pm

    #1362772

    Let me know what you find...

  • August 5, 2011 at 8:57 am

    #1364410

    Issue Resolved:

    This is a rather silly conclusion, but after rebooting the offending SQL Server during a maintenance window yesterday evening, this issue seems to have fixed itself. The "Recent CPU Consumption" report displays appropriately. I don't have a clear picture of what was actually causing the issue and why a reboot fixed it. I suspect stoping/restarting the SQL Service would have resolved it as well.

  • August 5, 2011 at 9:06 am

    #1364417

    the good old #1 fix for M$ :-D.

    Thanks for the feedback. It'll surely help someone else later.

    L8rs.

  • August 8, 2012 at 4:01 pm

    #1523488

    I was experienced same issue when we have databases in compatibility level 80 in 2008 R2 SP2 server.

  • October 5, 2012 at 2:41 am

    #1545935

    Hi! Every one^^

    I'm a fresh DBA / BI Developer from Taiwan, so I bump into this problem with a root cause of language datetime string format.

    So when I replace the content above in the file performance_dashboard_main.rdl, I can get rid of check_dependencies error.

    =min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")

    AS

    =Year(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + "-" + Month(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + "-" + Day(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + " " + Hour(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + ":" + Minute(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + ":" + Second(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString()

    THEN IT WORKS!!

    You can download the version I modified rdl file in my google site page.

    anibal.yeh@gmail.com ps. if ur in Taiwan, my cell phone is 0982121974

    Best regards

    Anibal

  • June 21, 2013 at 10:07 am

    #1626400

    I figure it out executing the script "setup.sql" located on the same directory that Performance Dashboard root install . ( My Server: 'C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Performance Dashboard').

    Rafael Gonçalez

    #changebrazil

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply