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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nemws1Database 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.