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?
Comments
2 comments
-
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. -
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
Add comment
Please sign in to leave a comment.