Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BigApple
Starting Member
3 Posts |
 Posted - 2003-11-07 : 19:29:24
|
| hi,@@PACK_SENT and @@PACK_RECEIVED tells the number of packets sent or recieved by SQL Server since it was last started. What does packet mean in these variables? Are they TCP packets?Is there a way to know the number of bytes in each packet?Why is measurement done in packets and not bytes?Thanks in advance,BigApple |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-07 : 19:33:38
|
| The packets refer to (TDS) Packets Refer to Tabular Data Stream Protocol in SQL BOL |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-07 : 19:35:59
|
quote:
Originally posted by BigApple
Is there a way to know the number of bytes in each packet?
Got a network sniffer? I'm sure a network admin would know the answer to this. You might want to check out some Windows networking site.quote:
Originally posted by BigApple
Why is measurement done in packets and not bytes?
Don't know. Ask MS. But probably because that is what a TCP/IP connection is already measuring.Tara |
|
|
|
BigApple
Starting Member
3 Posts |
Posted - 2003-11-07 : 19:40:57
|
| Thanks.How does one determine the default TDS packet size on a server?BOL says default is 4KB, but one can change to 512kB. Does not specify how.BA. |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-07 : 19:48:55
|
| Look up Network packet size Option in BOL |
|
|
|
|
|
|
@@Pack_SENT