Solved

SQL 2000 - Packet Errors

Posted on 2002-06-03
1
242 Views
Last Modified: 2011-04-14
At my company we have 3 SQL Servers running on Win Server 2000 and SQL 2000.  1 was built from scratch and gets no errors, 2 were upgraded from NT4/SQL7 and I get quite a few packet errors showing up on sp_monitor.  
Has anyone else seen this?  What did you do to fix it?
0
Comment
Question by:hachmanj
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 7051394
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ma-mz_5lte.asp

THese counter indicate network usage, and errors indicates that your network might not be stable for that server...

Have you any events in the event viewer that correlates with this?

CHeers
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now