Posted on 2004-08-16
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.