Geek Answers Handbook

In what format are SQL Server data serialized when sent over the network?

The reason I ask this question is because we plan to read A LOT (several GB) of data from a SQL Server database in a .NET application for processing. I would like to know how much space overhead needs to be calculated for each entry to assess the impact on our network traffic.

eg. a record consists of 5 integers (which is 4 * 5 = 20 bytes of data). How many bytes are physically transferred per record? Is there an exact formula or rule?

+5
source share
5 answers

SQL Server uses the TDS protocol . And MSDN

, . GBs , .

+10

, Wireshark .

+4

, .

, , .

, . :

, NIC ? , , , . 1Gb-, , , 300Mb - . , - .

? , , os .., . $100 8 1Gb TRENDNet , cisco 1 000 .

"" . , . , .

, TCP Offloading, - . nic , , .

. , , . , 90% - , , , , 25% .

, , , SQL, . , . ; , , 10%.

+4

SQL . , . , . : SQL Server (ADO.NET) bcp Utility.

0

TDS . SQL Server , .. , , - , , SQL Server (, Service Broker). , TDS , , SQL Server, TDS-, .Net-, .

, - , , , , .

0

More articles:


All Articles