none
Performace Dashboard Reports Error: a data source has not been supplied

    Question

  • Just installed PDR on SQL 2008 R2 SP1 Std Edition x86 with ms_ticks solution. It works on most of the clicks but not on a few like user requests, active traces, databases, cpu uaage blue bar etc, Fails with error:

    a data source instance has not been supplied for the data source 'check_dependencies'

    Sql reboot : nogo.


    D

    Monday, April 23, 2012 10:49 PM

Answers

  • In March Microsoft released a new version of Performance Dashboard Reports that is compatible with 2008R2. We have been running this version against several 10.50.2500 instances for some time now and do not see the check_dependencies error. If you haven't tried this already my suggestion is that you install this version and see if it resolves the issue. The only issue we have run into is that occasionally we'll get an overflow error on some of the reports if the service has been running for a month or so with no restart. Other than that it has been great.

    The download page is here:

    http://www.microsoft.com/en-us/download/details.aspx?id=29063

    I agree that Performance Dashboard is a great tool and am glad they have picked it back up. As for the specifics of the dataset error I've dug into it a bit but don't have much more than a guess as to how to troubleshoot.

    Hope that helps!


    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you.

    • Marked as answer by SQLRocker Saturday, May 05, 2012 12:13 AM
    Thursday, May 03, 2012 8:30 PM

All replies

  • On SQL Server 2008 use:

    1. Activity Monitor

    2. Server standard reports

    3. Database standard reports

    Performance tuning article:

    http://www.sqlusa.com/articles/query-optimization/


    Kalman Toth SQL SERVER & BI TRAINING

    Tuesday, April 24, 2012 10:52 AM
    Answerer
  • Not what I asked, Why are you wasting your time & mine? Don't use my thread as a advertising board.


    D

    Tuesday, April 24, 2012 8:41 PM
  • Here is the only information I could find on this issue, and there is no workaround - http://connect.microsoft.com/SQLServer/feedback/details/691156/error-while-trying-to-run-a-sql-performance-dashboard-report-which-works-on-sql-server-2008-2008r2-but-not-on-denali-ctp3

    You could try to contact Rob Carrol as he had a blog on Performance Dashboard Reports for SQL Server 2008 - http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx.  There was a comment by James (4-11-2011 at 8:20AM) similar to yours but it has not been answered that I saw.

    I hope this helps.

    Noral

    Tuesday, April 24, 2012 10:23 PM
  • Already saw that link. Posted on Rob's blog.

    D

    Tuesday, April 24, 2012 11:55 PM
  • Hi SQLRocker,

    Please ensure that you have enabled the instance for use with the Performance Dashboard reports on the SQL Server instance you want to monitor, deploy the reports and data source to your Report Server and you’re ready to roll.

    You can refer to this blog which also written by Rob:
    http://blogs.technet.com/b/rob/archive/2010/09/28/hosting-the-performance-dashboard-reports-in-ssrs.aspx


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, April 25, 2012 6:05 AM
    Moderator
  • RS.. No I don't want to use RS.  Not a RS guy.

    D

    Wednesday, April 25, 2012 6:21 AM
  • SQLRocker,

    Question: have you tried the Data Collector and Management Data Warehouse reports that shipped with SQL2008?

    Thanks,

    Ahmed.

    Wednesday, April 25, 2012 6:45 PM
  • I know about MDW, that's not what am I asking about here. I already know of the various tools available in SQL and I also know that MDW is the reason why MSFT isn't shipping the official PDR for 08. Anyone, who wants to spend time replying to this post, ONLY do it if it is concerning the specific error above, will save my time & yours.

    D

    Wednesday, April 25, 2012 7:07 PM
  • In March Microsoft released a new version of Performance Dashboard Reports that is compatible with 2008R2. We have been running this version against several 10.50.2500 instances for some time now and do not see the check_dependencies error. If you haven't tried this already my suggestion is that you install this version and see if it resolves the issue. The only issue we have run into is that occasionally we'll get an overflow error on some of the reports if the service has been running for a month or so with no restart. Other than that it has been great.

    The download page is here:

    http://www.microsoft.com/en-us/download/details.aspx?id=29063

    I agree that Performance Dashboard is a great tool and am glad they have picked it back up. As for the specifics of the dataset error I've dug into it a bit but don't have much more than a guess as to how to troubleshoot.

    Hope that helps!


    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you.

    • Marked as answer by SQLRocker Saturday, May 05, 2012 12:13 AM
    Thursday, May 03, 2012 8:30 PM
  • hi, could you please go through the given link, it may helpful.

    http://www.sqlservercentral.com/Forums/Topic1088063-391-2.aspx#bm1155125

    Friday, May 04, 2012 6:33 PM
  • Awesum Matt, Thanks !! They also added 'Active Xevent Sessions', cool mann Thanks!!

    --

    Nanurahi: I had already read that link & thats why I said sql reboot , nogo on my very 1st post.


    • Edited by SQLRocker Saturday, May 05, 2012 12:22 AM
    Saturday, May 05, 2012 12:18 AM
  • Hi Matt,

    I just have downloaded the new Dashboard and tried  to run it against a SQL Srv 2008 R2(build .2500). It seems that everything works fine except when I try to open the CPU utilization. Then I get "A data source instance has not been supplied for the data sorce 'CHECK_DEPENDENCIES'. When I refresh that report, then a new error comes up:Error converting data type nvarchar(max) to datetime.

    So, if you or anyone else, who is follwoing this post, has any ideas on how to resolve this. Any hint is greatly appreciated.

    Regards

    Dirk

    EDIT:

    Problem solved. More information here:

    http://ask.sqlservercentral.com/questions/91970/perf-dashboard-2012-data-source-instance-not-suppl.html

    Friday, July 27, 2012 7:39 AM
  • 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.

    https://sites.google.com/a/aisowhat.com/data2info/sql-server/sqlsrv-db-engine/dbe-performance-dashboard-2012

    =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

    Friday, October 05, 2012 8:36 AM