<div>
Any idea what the default TCP ports are for executing Microsoft SQL Server 2005 Stored procedures ?
</div>


Any idea what the default TCP ports are for executing Microsoft SQL Server 2005 Stored procedures ?

<div>
Hi Steve,<br />
I used Wire-Shark to capture on TCP port 1433 and found that once the ADO connection had been established, &nbsp;the total exchange of data for the remote execution of the stored procedure amounted to 237 bytes.<br />
<br />
Thanks for your comments.
</div>


Hi Steve,
I used Wire-Shark to capture on TCP port 1433 and found that once the ADO connection had been established,  the total exchange of data for the remote execution of the stored procedure amounted to 237 bytes.

Thanks for your comments.

<div>
<div class="content wysiwyg-content">
How can I estimate the local area network utilisation involved in remotely executing a simple SQL Server Stored Procedure ?<br />
<br />
I have a windows application that uses ADO to execute a stored procedure on a Microsoft SQL Server 2005 database server.<br />
The stored procedure is simple and returns a single result in an &nbsp;integer output parameter. <br />
<br />
I am executing this procedure every 10 seconds and have been asked to estimate the &quot;network utilisation&quot;. &nbsp;There are no input parameters to the stored procedure. I will be answering the question as &quot;virtually no network utilisation&quot; but I anticipate being asked how to justify this statement.
</div>
</div>


How can I estimate the local area network utilisation involved in remotely executing a simple SQL Server Stored Procedure ?

I have a windows application that uses ADO to execute a stored procedure on a Microsoft SQL Server 2005 database server.
The stored procedure is simple and returns a single result in an  integer output parameter. 

I am executing this procedure every 10 seconds and have been asked to estimate the "network utilisation".  There are no input parameters to the stored procedure. I will be answering the question as "virtually no network utilisation" but I anticipate being asked how to justify this statement.

Network utilisation executing a stored procedure

Networking is the process of connecting computing devices, peripherals and terminals together through a system that uses wiring, cabling or radio waves that enable their users to communicate, share information and interact over distances. Often associated are issues regarding operating systems, hardware and equipment, cloud and virtual networking, protocols, architecture, storage and management.

Networking

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.