Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Table SPT_Monitor

Posted on 2004-08-16
Medium Priority
Last Modified: 2012-08-13
I have a question about table spt_monitor.  I'm a network guy working on my CCNA so I really don't know too much about SQL, anyway our company is running Microsoft SQL 2000 and our "DBA" looks at a table called SPT_Monitor in the Master database in it there is a field pack_errors, and every so often they accumulate and he insists that its a problem with our network and that we're losing packets all over the place, but I check my routers and all seem fine we are located in Dallas TX we have offices located in Las Vegas, San Antonio and a couple others, all of our office use this SQL server and depend on it, I can ping all of our offices and get back all my responses in less than 70 ms across our VPN tunnels none of my routers show anything weird, and I can access every location using PCAnywhere & remote desktop with out a problem.  The thing is that I don't know what this table is logging and our "DBA" shows management this table and most of them now believe there is something seriously wrong with our network configuration.  I’ve shown them the ping times, the router interfaces but SQL still continues to log errors in this table.  Can someone give me some more info on this table what exactly is it logging?  And if it is a network error can it be pin pointed?

Any help would be greatly appreciated.
Question by:vbeltran
  • 4
  • 3
LVL 34

Expert Comment

ID: 11812469
Does your DBA know that he shouldn't be accessing the system tables directly?? :)

This is fairly normal--most of our servers have errors in them--just the nature of the beast.  Doesn't mean there is a network problem, just means that SQL Server had a problem with the packet for some reason (for all you know, someone connected on your default SQL Server port with a non-sql server request--could show up as a packet error as well).

How how are the counters??


Author Comment

ID: 11812689
I'm not too sure about our "DBA"...

Do you mean Memory and CPU on SQL??

Memory is at about 1/3 (out of 3 gigabytes)
CPU between 1-5% varies
Diskspace is at about 2/3 right now out of 200g

Incase you mean Router here it is.

  Last input 00:00:00, output 00:00:00, output hang never
  Last clearing of "show interface" counters 5d08h
  Input queue: 0/75/9/0 (size/max/drops/flushes); Total output drops: 620
  Queueing strategy: fifo
  Output queue :0/40 (size/max)
  5 minute input rate 190000 bits/sec, 27 packets/sec
  5 minute output rate 44000 bits/sec, 28 packets/sec
     8275316 packets input, 3614534346 bytes, 0 no buffer
     Received 0 broadcasts, 0 runts, 0 giants, 0 throttles
     0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored, 0 abort
     8427169 packets output, 1945635898 bytes, 0 underruns
     0 output errors, 0 collisions, 0 interface resets
     0 output buffer failures, 0 output buffers swapped out
     0 carrier transitions
     DCD=up  DSR=up  DTR=up  RTS=up  CTS=up

LVL 34

Expert Comment

ID: 11812735
No, what's the actual figure the "DBA" is seeing in the pack_errors column?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 11813123
Right now its at 0 but only because we rebooted the server really early this morning but in a few days it'll be up to 20 or more, he states that these packet errors are caused because of poor network performance and that the if the errors accumulate to 60 packet errors or more it'll cause an outage, we've had outages before caused by poor code development and queries for large amounts of data and when that happens the packet errors increase, and that’s when all the finger pointing starts.  I don't know much about SQL but my network is being accused of running poorly when in fact all is well.  Is there anything like an article or something that'll tell me more about this table and what its purpose is?  Or how can I cause a packet error purposely? (without bringing down our system)  Just so I can show what causes them
LVL 34

Accepted Solution

arbert earned 1200 total points
ID: 11813517
I don't agree with that at all....We have 562 errors on a private server right now that has a VLAN across fibre to another server.  Our server has never exhibited problems.

I think your "DBA" needs to put some profiler traces on the SQL box and run Windows Perfmon to see what's really causing the problem.  "Share " the job with him (at least make him think you care and it could possibly be part of your problem) and tell him you will run the network traces at the same time he runs his Profiler/Perfmon.  When you see the errors increase or the server "dies" correlate the times and compare the logs.

Author Comment

ID: 11813529
I'll try it out and let you know what happens.

Thanks for you help.
LVL 34

Expert Comment

ID: 11813733
hmm, kind of weird to bash a DBA for a change lol....Actually, I see his point too, but you've backed up your position very well.  The current environment I work in, the network guys are ALWAYS suspect--they never backup anything and just always say "that's the way it is"..Definitive information is a good thing :)

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

575 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