Noob .... question about time stats

InsanelyOne

Probably a stupid question, but if I'm profiling a VB.NET program that is accessing a database, is the time spent waiting on results from a stored procedure or SQL call included? For example, if I have a function that loads a dataset via a stored procedure, does the time reported include the time spent waiting for the SQL to run and return the results, or would it just include the actual time the program spent loading the dataset in memory?

Brian Donahue

Hi,

ANTS Profiler will report the total method time in 'real' elapsed (wall-clock) time. This will include the connection times, query times, and whatever other objects your methods are simply waiting for to return.

simon galbraith

Hi,
There is also an article in the help file that gives a broader overview of how to understand the performance profiling results:
http://help.red-gate.com/help/ANTSProfi ... sults.html
Simon