Stored Procedure Profiler Duration

Hi

We have a stored procedure that returns a data set.

When viewing  the Duration value for this stored procedure in SQL Profiler, the duration value is much larger when the procedure is executed across the WAN compared to the value when executed on the same LAN.

This implies the duration value includes the time required to create the data set PLUS the time taken to transmit it back to the calling device. Is this true? Experience comments welcome.

Many Thanks
antonmsAsked:
Who is Participating?
 
nemws1Connect With a Mentor Database AdministratorCommented:
Yes, the duration listed in the profiler includes the transmission time back to the client.

Are you using SSMS both locally and over the WAN, or are you using 2 different clients (SSMS locally and .NET over the WAN?)  If the latter, it could be ARITHABORT.  Here's a long, detailed document describing all the possibilities of additional slowdown:

Slow in the Application, Fast in SSMS? Understanding Performance Mysteries
0
All Courses

From novice to tech pro — start learning today.