<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
We have a stored procedure that returns a data set.<br />
<br />
When viewing &nbsp;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.<br />
<br />
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.<br />
<br />
Many Thanks
</div>
</div>


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

Stored Procedure Profiler Duration

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Windows operating systems have distinct methodologies for designing and implementing networks, and have specific systems to accomplish various networking processes, such as Exchange for email, Sharepoint for shared files and programs, and IIS for delivery of web pages. Microsoft also produces server technologies for networked database use, security and virtualization.