June 4, 2003 at 6:01 am
I had Sql 2000 standard edition installed in win2000 sever with sp3 installed on Compaq PROLAINT ML370 ( 1.4Mhz with 1Gb Ram and 30 GB Hard Drive ), the problems is that after 20 min from switching on the server the sqlservr.exe processes start using 97% CPU causing my LAN network to shutdown ( it¡¦s not possible to ping any address or access the internet for any computer connected to My LAN network ) ,I tried to kill sqlservr.exe processes but it¡¦s sat ¡§stopping the presses impossible: access denied ¡§, but when I restart the server and shutdown Sql server , everything will be OK, I update my win2000 and sql server without any result.
I would like to know if any body know how to solve this problem....
June 4, 2003 at 6:24 am
Have you tried running sqldiag.exe when the problem occurs to capture what is happening inside sql?
Steven
June 4, 2003 at 8:01 am
I have run the sqldiag.exe. It shows the last three log files are unable to open. Meanwhile, What kind of command should I use to capture the command? Many thanks!
June 4, 2003 at 8:06 am
sqldiag writes its output into a file (the default it the sql logs directory)
Take a read of the sqldiag Utility in books online.
Steven
June 4, 2003 at 11:40 am
I have checked the log files from Enterprise Manager, but records are normal.
June 4, 2003 at 12:04 pm
You said it was consuming all the bandwidth. Has anyone looked at the network traffic to see exactly what it is?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 4, 2003 at 6:01 pm
Yes, I do. I have a program called "Netpersec". It monitors incoming and outgoing traffic. When my problem happened, the outgoing traffic increases to 1.2Mbits/s ~ 2.Mbits/s from about 10KB. Therefore, just few bits left for outgoing.
I also called my ISP, coz I thought it was their problem at first. However, they gave same answer and suggested me reinstalled OS.
June 5, 2003 at 7:16 am
It sure sounds like Slammer, but you have SP3 already applied. Have you looked at the traffic with an analyzer to see where the data is going? That much traffic is extreme for SQL to be putting out.
June 5, 2003 at 7:16 am
That's the amount, not the type. Figuring out exactly what the traffic is may give you an indication of what's going on.
For instance, a lot of resends may mean the network settings aren't right (perhaps the NIC should be manually to 100 Full).
Or if you see a lot of outband attempts to connect to UDP 1434, it may be a sign of the Slammer worm.
Of if you see a lot of outbound connects to TCP 1433 it may be indicative of one of Spida type worms...
Or it may be something else entirely. The point is, since the network traffic is a key indicator something is wrong, perhaps by looking at exactly what the traffic is you might have an idea as to the cause.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 5, 2003 at 7:19 am
Keep in mind that there's a hotfix to repair a memory leak and it came with the old netlib files. Some people who had been patched got unpatched when they installed the memory leak hotfix. That was one of the lessons learned. Of course, that memory hotfix was pre-SP3, though.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply