sql calls timing in call tree dont match with DB calls view

Code profiling for .NET developers.

Moderator: dom.smith

sql calls timing in call tree dont match with DB calls view

Postby rgupta77 » Thu Jun 06, 2013 1:39 pm

The timing for SQL calls as noticed in the call tree view don't match with the timing for sql calls in the database calls view.

In the call tree view the timing is shown to be <0.001 ms whereas the timing in the database calls view for the same sql query is around 40ms.

Can you explain why I see this discrepancy
rgupta77
 
Posts: 2
Joined: Thu Jun 06, 2013 1:33 pm

Postby dene.boulton » Thu Jun 06, 2013 2:21 pm

Hello,

I believe you are likely viewing the call-tree in CPU time; directly above the call-tree on the right is a dropdown to select the 'Timing mode', change this to Wallclock time and the values should match what you are seeing in the Db calls view.


Hope that helps.
Dene Boulton
Red Gate
dene.boulton
 
Posts: 53
Joined: Wed Oct 12, 2011 12:44 pm
Location: Cambridge

sql calls timing in call tree dont match with DB calls view

Postby rgupta77 » Fri Jun 07, 2013 7:55 am

when I change to wall clock time, I don't see any items in the call tree. It says no significant time was spent in methods with source code. consider switching to CPU time
rgupta77
 
Posts: 2
Joined: Thu Jun 06, 2013 1:33 pm

Postby dene.boulton » Fri Jun 07, 2013 10:32 am

That could be the case, as it depends on the proportionality of time spent in your code vs framework / third party code for the region of time you have selected in the timeline.
Your code will still be in the call-tree stacks, you can use Find for regular method calls (CTRL+F), and for SQL you can go to a specific Query in the 'Database Calls view' where using the blue 'NET' button will take you to that call in the call-tree.

See http://documentation.red-gate.com/displ ... calls+view
(Sub-heading: Linking back to your code)
Dene Boulton
Red Gate
dene.boulton
 
Posts: 53
Joined: Wed Oct 12, 2011 12:44 pm
Location: Cambridge


Return to ANTS Performance Profiler 8

Who is online

Users browsing this forum: No registered users and 1 guest