Solved

SQL 2000 - Packet Errors

Posted on 2002-06-03
1
244 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

914 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

21 Experts available now in Live!

Get 1:1 Help Now