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.