April 4, 2011 at 7:59 am
Good morning,
I have encountered an error when clicking on the "System CPU Utilization" graph. The error says:
A data source instance has not been supplied for the data source 'CHECK_DEPENDENCIES'
I have altered the stored proc, usp_Main_GetSessionInfo. To resolve an earlier date overflow error, I changed the idle_connection_time from:
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
And now I have the CHECK_DEPENDENCIES error. Does anyone know how to resolve this?
April 4, 2011 at 1:08 pm
Check the below links will help you or not.
http://blogs.msdn.com/b/bimusings/archive/2005/07/01/434659.aspx
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 5, 2011 at 2:52 pm
What version of 2005 are you running. Apparently if you're not up to at least Sp2 this won't work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2011 at 7:10 am
dajonx (4/6/2011)
I'm on 2008 R2 Enterprise 64-bit.
am i missing something?
isnt performance dashboard SQL 2005? and replace with data collection in 2008?
July 13, 2011 at 3:43 pm
We just ran into this and I think it's because one of the databases is in restoring state, and another instance with the same error a database is unavailable. I am running into a similar issue (different error) on some homegrown queries that hit the same DMVs. So I think this is caused by database state. Where exactly it occurs in the perf dashboard report code I can't say. We're running perf dashboard against SQL 2008 R2 and after the ms_ticks fix they usually run fine.
August 2, 2011 at 2:28 pm
I am having this same error with the performance dashboard reports on SQL 2008 r2:
When I click the blue CPU bar from the "System CPU Utilization" section, I get the error: "A data source instance has not been supplied for the data source 'CHECK_DEPENDENCIES'.
However, when I run the same report against a different SQL 2008 R2 server, the "Recent CPU Consumption" page displays without error. I have ensured that I am using the same .rdl file against both servers, and I have ensured that the dashboard stored procedures are identical on each of the servers. I'm puzzled why it works on one server and not the other.
Does anyone know how to fix this issue?
August 2, 2011 at 2:43 pm
dajonx (4/4/2011)
Good morning,I have encountered an error when clicking on the "System CPU Utilization" graph. The error says:
A data source instance has not been supplied for the data source 'CHECK_DEPENDENCIES'
I have altered the stored proc, usp_Main_GetSessionInfo. To resolve an earlier date overflow error, I changed the idle_connection_time from:
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
And now I have the CHECK_DEPENDENCIES error. Does anyone know how to resolve this?
Longshot... does the query run when you paste it in SSMS? AFAIK you did the correct fix for the arith error.
August 2, 2011 at 3:18 pm
Thanks for the reply.
Yes, I have corrected the math error.
Yes, I can successfully run the the sql in SSMS. Now... what I see SQL Profiler when I run performance_dashboard_main.rdl on the SQL 2008 R2 server where this is working correctly is that it calls the 5 main procs:
-usp_Main_GetRequestInfo
-usp_Main_GetCPUHistory
-usp_Main_GetSessionInfo
-usp_Main_GetRequestWaits
-usp_Main_GetMiscInfo
Then, when I click the blue CPU Utilization line, there are no SQL calls that occur at all - so I'm presuming that is is using cached data from the initial calls to populate the "Recent CPU Consumption" report. This is the part that generates the data source error on the other 2008 r2 server. Since I'm using the same .rdl files and identical procs on both servers, I would expect to get the same results. Very peculiar.
August 2, 2011 at 3:22 pm
I'd only be left with close everything and hit refresh after reopening.
I had similar issues when wanting to change the server the connection was pointing to.
August 2, 2011 at 4:28 pm
I tried that as well. Even tried using different SSMS installs on other PCs, but to no avail. I'll continue to troubleshooting this. thanks.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply