Performance Dashboard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Performance Dashboard

20 posts, Page 1 of 2

1 2 »»

Performance Dashboard

Rate Topic

Display Mode

Topic Options

Author

Message

dajonx

Posted Monday, April 04, 2011 7:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

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

dajonx

Posted Monday, April 04, 2011 1:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

Does anyone happen to know how to resolve this issue? Unsure

My Blog!

Post #1088248

C.K.Shaiju

Posted Monday, April 04, 2011 1:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 03, 2013 10:42 PM
Points: 179, Visits: 561

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

Post #1088251

dajonx

Posted Tuesday, April 05, 2011 1:21 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

It's still a no go... No one ran into this problem before?

My Blog!

Post #1088867

Grant Fritchey

Posted Tuesday, April 05, 2011 2:52 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:58 AM
Points: 13,375, Visits: 25,157

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

dajonx

Posted Wednesday, April 06, 2011 6:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

I'm on 2008 R2 Enterprise 64-bit.

My Blog!

Post #1089201

dajonx

Posted Thursday, April 07, 2011 6:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

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

Marco V

Posted Thursday, April 07, 2011 7:10 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 7:10 AM
Points: 462, Visits: 501

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

dajonx

Posted Friday, April 08, 2011 7:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 1:04 PM
Points: 134, Visits: 857

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

kmbailey

Posted Wednesday, July 13, 2011 3:43 PM

Forum 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 »

20 posts, Page 1 of 2

1 2 »»

Permissions