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 |
|
dcarva
Posting Yak Master
140 Posts |
 Posted - 2004-05-01 : 11:04:49
|
| Hello,I am running daily SQL statistics and having them sent to me via email. I am seeing packet errors...about 800 daily. I use the @@PACKET_ERRORS variable. Any idea what could be causing this?Thanks,Danny |
|
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-05-01 : 11:10:21
|
| I was wrong. It's 800+ since SQL was last started. But I am still not sure what this really means. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-02 : 19:29:57
|
| It just means that there were errors in packets detected which were sent or received by SQL Server since the SQL Server last started. If the number is high, you should have a trace placed on the network to see where the errors are occurring. This can signify a card or cable starting to go bad. If it's occurring across the network, it can also signify a router or switch going bad.I wouldn't worry about it too much unless you see the number growing each day. It's possible that maintenance was being performed on the network and you weren't told (which should never happen). You might want to ask your IT department if anything has happened on the network.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
dcarva
Posting Yak Master
140 Posts |
Posted - 2004-05-04 : 10:10:21
|
| Good info. Thanks! |
|
|
|
|
|
|
Packet errors