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 |
|
russray
Starting Member
27 Posts |
 Posted - 2008-05-12 : 11:51:35
|
| I see in several recommendations I found from searching for answers why we were losing the connection to the database. One of these was tweaking the Network Interface Card to ensure it is set to 1024 in the registery. Another was twaeking the TCP-IP setting for windows underHKey_Local_machine\System\CurrentControlSet02\Services\TCPIP\Parameters. Most of these did not mentioned SQL Server 2005. I wondering if someone of more experience with SQL Server 2005 than I can address if this action is required in the newer version.Thanks for any feedback,Russ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:59:01
|
| You can change sql traffic's package size with sp_configure. |
 |
|
|
|
|
|
Optimizing TCP-IP Settings for 2005 Version?