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 8
ANTS Performance Profiler 8 forum

No Database is available for the currently selected Range

Search in ANTS Performance Profiler 8 forum
Post new topic   Reply to topic
Jump to:  
Author Message
basuds83



Joined: 14 Oct 2013
Posts: 2

PostPosted: Mon Oct 14, 2013 7:49 pm    Post subject: No Database is available for the currently selected Range Reply with quote

I've started using ANTS Performance Profiler 7.4 Pro Edition but but whenever I'm selecting Database Calls it's throwing "No Database is available for the currently selected Range" message for any profiling mode.

Am I missing something?

Moreover in the profiling result I'm seeing the methods which has maximum hit count, it's not showing the source code. only says "Hidden methods without source". What does it mean? how do I access those source?

Please let me know.
_________________
Thanks & Regards,
Basu_
Back to top
View user's profile Send private message
jessica.ramos



Joined: 23 Apr 2012
Posts: 215

PostPosted: Tue Oct 15, 2013 10:24 pm    Post subject: Reply with quote

Hello,

Thank you for your post!

There are a few different reasons why your SQL calls may not showing up. A few common things to check for..

-Are you using sampling mode of profiling?
-Are you are profiling an application compiled into an NGen profile image?
-Does it make any difference if you run the profiler explicitly as administrator?

Should none of those apply, the problem could be one of the following:
-Your application calls a database using unsupported ADO.NET drivers.
-Your SQL calls are made asynchronously.
-Your calls use a non-standard SQL API.

You can find more about these issues here: http://documentation.red-gate.com/display/APP8/Troubleshooting+SQL+call+and+HTTP+request+profiling

Also, it's not yet reflected in that documentation, but we've actually just released version 8.3 of the profiler which adds support for MySQL and PostgreSQL profiling. It may be worth updating (Help>check for updates) if that might be the issue in your case!

Regarding the missing source, there is likely an issue with that assembly's pdb files. Kindly take a look at this article for troubleshooting tips: http://documentation.red-gate.com/display/APP80/Troubleshooting+PDB+problems

Hope this information helps!
_________________
Jessica Ramos
Technical Support
Red Gate Software Ltd.
Back to top
View user's profile Send private message
basuds83



Joined: 14 Oct 2013
Posts: 2

PostPosted: Thu Oct 17, 2013 6:57 pm    Post subject: Reply with quote

-Are you using sampling mode of profiling?

I’ve tried these profiling but no success:

1.Line-Level and Method – level timings; all-methods(most detailed)
2.Method – level timings; all-methods(faster)
3.Line-Level and Method – level timings; Only methods with source(detailed)
4.Method – level timings; Only methods with source(very fast, most accurate)

-Are you are profiling an application compiled into an NGen profile image? No
-Does it make any difference if you run the profiler explicitly as administrator? No

In the service layer, our application is using IBMDB2 database with OleDb provider. Does ANTS not support this?

Please let me know. Also is there any workaround to profile DB2 database calls?
_________________
Thanks & Regards,
Basu_
Back to top
View user's profile Send private message
jessica.ramos



Joined: 23 Apr 2012
Posts: 215

PostPosted: Fri Oct 18, 2013 12:20 am    Post subject: Reply with quote

Hi Basu,

No, the profiler does not support DB2 database profiling, I'm sorry to say. :/
_________________
Jessica Ramos
Technical Support
Red Gate Software Ltd.
Back to top
View user's profile Send private message
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