'SQL trace duration

I have a web PHP application that calls a determined stored procedure.

Tracing the call from the PHP application I get a duration of about 30seconds but when I copy the called stored procedure (so same input parameters) to the SSMS and run it it takes 1 second.

Where are the extra 29 seconds going? The payload of the query from the google developer tools is about 250kB so I don't think it's a network data transport time (the SQL server and PHP application are on the same LAN).

What does the duration column comprehend?

Thanks

phpsql-serverduration


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions