Stored Procedure Profiler Duration

Posted on 2014-08-16
Last Modified: 2014-08-22

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
Question by:antonms
    1 Comment
    LVL 23

    Accepted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now