In petshop:
Conn_string_non_dtc: "Server = localhost; user id = mspetshop; Password = password; database = mspetshop; min pool size = 4; Max pool size = 4; packet size = 3072"/>
Conn_string_dtc_inv: "Server = localhost; user id = mspetshop; Password = password; database = mspetshop; min pool size = 4; Max pool size = 4; packet size = 1024"/>
There is a difference in packet size. 1024 and 3072. Is there 2nd connections when users increase?
Check. sqlserver2000
The Network Packet Size Option sets the package size (in bytes) used throughout the network ). Packages are fixed-size data blocks that transmit requests and results between the client and the server. Microsoft & reg; SQL Server & #8482; sets the default data packet size to 4096 bytes. If an application needs to perform a large number of copy operations, or send or receive a large amount of text or image data, a larger package size than the default value can improve the efficiency, because it can reduce the number of network reads and writes. If the application sends and receives a small amount of information, you can set the package size to 512 bytes, which is sufficient for most data transmission.