Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Performance Dashboard Expand / Collapse
Author
Message
Posted Monday, April 04, 2011 7:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
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?


My Blog!
Post #1088063
Posted Monday, April 04, 2011 1:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
Does anyone happen to know how to resolve this issue?

My Blog!
Post #1088248
Posted Monday, April 04, 2011 1:08 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:26 AM
Points: 196, Visits: 640
Check the below links will help you or not.

http://blogs.msdn.com/b/bimusings/archive/2005/07/01/434659.aspx

http://vbcity.com/blogs/xtab/archive/2010/04/29/a-data-source-instance-has-not-been-supplied-for-the-data-source-error.aspx


_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1088251
Posted Tuesday, April 05, 2011 1:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
It's still a no go... No one ran into this problem before?

My Blog!
Post #1088867
Posted Tuesday, April 05, 2011 2:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 14,788, Visits: 27,265
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1088933
Posted Wednesday, April 06, 2011 6:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
I'm on 2008 R2 Enterprise 64-bit.

My Blog!
Post #1089201
Posted Thursday, April 07, 2011 6:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
Does anyone think that I should try reinstalling the Dashboard again since it doesn't seem like anyone has encountered a problem like this?

My Blog!
Post #1089834
Posted Thursday, April 07, 2011 7:10 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:51 AM
Points: 462, Visits: 517
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?

Post #1089855
Posted Friday, April 08, 2011 7:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:21 AM
Points: 145, Visits: 898
Oh, I thought it was 2008 compatible; just have to change a stored procedure in the setup script due to the DMV column changes. It was working fine until last week.

I'll have to look into data collection though...


My Blog!
Post #1090636
Posted Wednesday, July 13, 2011 3:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 05, 2012 2:22 PM
Points: 1, Visits: 90
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.
Post #1141396
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse