Red Gate forums :: View topic - No Database is available for the currently selected Range
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 7
ANTS Performance Profiler 7 forum

No Database is available for the currently selected Range

Search in ANTS Performance Profiler 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Chaitu



Joined: 08 Jun 2012
Posts: 3

PostPosted: Fri Jun 08, 2012 7:37 am    Post subject: No Database is available for the currently selected Range Reply with quote

Hi,
I am vewing the message "No Database is available for the currently selected Range" after selecting Database calls section in the performance profiler after I am done with profiling. Mad

Even I tried in the below manner but the result seems to be same:
1. selected Call tree view, and Wall-clock time on the results toolbar.
2. selected the portion of the timeline
3. Clicked on Database Calls.

In the call tree,I am not able to see any database Icon. Hence Eventhough I click on Database calls the result is same.

I have tried connecting to the database which is in my local development system and also to the databse which is in remote.

I have also browsed trough the logs, But I could not find any stuff related to database and the error. Confused


Can u please ley me know
1)why I am not able to view SQL icon in the Call tree
2)Are there any special settings that have to be done before continuing with profiling
3) Any things to Cross check in scenerios like this.
Back to top
View user's profile Send private message
dene.boulton



Joined: 12 Oct 2011
Posts: 53
Location: Cambridge

PostPosted: Fri Jun 08, 2012 8:45 am    Post subject: Reply with quote

Good Morning,

From your description I am thinking you are using version 7.2, but can you please confirm this?

What are type/versions of the databases you are trying to access?
_________________
Dene Boulton
Red Gate
Back to top
View user's profile Send private message Send e-mail
Chaitu



Joined: 08 Jun 2012
Posts: 3

PostPosted: Fri Jun 08, 2012 9:43 am    Post subject: Reply with quote

Hi Dene:
Here are the versions I am using::

Red Gate: 7.2
Sql Server : 2008 Version 10.0.1600.22
Back to top
View user's profile Send private message
Laura Morley



Joined: 22 Jun 2011
Posts: 34
Location: Red Gate Software

PostPosted: Fri Jun 08, 2012 9:59 am    Post subject: Reply with quote

Hmm - thanks for the extra information, Chaitu.

What profiling mode are you using? Sampling mode doesn't return any data on database calls - if you use another mode, you should see SQL call results.

You also wouldn't see database call profiling results if you're using the Standard edition of ANTS Performance Profiler - SQL call profiling is available only in Pro edition.

If you're using Pro and a non-sampling mode, can you tell us any more about the API your application uses to make SQL calls? It's possible it's one we aren't yet instrumenting.
Back to top
View user's profile Send private message
Chaitu



Joined: 08 Jun 2012
Posts: 3

PostPosted: Thu Jun 14, 2012 1:26 pm    Post subject: Reply with quote

Hi Dene, here are the required details::


Profiling mode we are using: Line -Level and method Level Timings;all methods(most detailed)::::::

We are using ANTS PROFILER PROFESSIONAL EDITION.

our Application uses Microsoft API's (DAL) ,Enterprise libraries 4.0 to connect to the database..

kindly let me know if any information is needed...
Back to top
View user's profile Send private message
dene.boulton



Joined: 12 Oct 2011
Posts: 53
Location: Cambridge

PostPosted: Thu Jun 14, 2012 2:14 pm    Post subject: Reply with quote

Hello,

Would there be any chance that you would be able to send us a results file for a session that exhibits this behaviour? A simple test application would suffice - if you are unable to send results for one of your products.

If so, you can send it to my email (buttons below).

Thanks,

Dene.
_________________
Dene Boulton
Red Gate
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group