Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-04-09 : 13:03:52
|
khoo writes "I manage a few SQL 6.5 server which is running 24x7 mission critical. Normally, All the server given this message onces a while (may be one or two time a day and the durations is less then 2 min) and this didn't effect the user. But, currently, one of the server given a block of this error and it cause a lot of clients have difficulty to connect to the server or hang. But this situation last for 20min to 30min and it come back to normal by itself. This happen intermitently and It make me very difficult to trouble shoot. Below is some descriptions, I hope somebody can help me or give me some idea on how to slove it. Thanksbtw : I ask network guy to check the network but it seem like no problem on the network.The utilization of the network is less then 10% and the clients is able to ping to server. Server OS : win NT4 with latest service packDatabase : SQL 6.5 with post service pack 6aConneciton : TCP/IP port 1433Clients : Win 95 or Win 98No Of user : About 200The block of error as below:2002/04/01 14:00:22.58 ods Error : 17824, Severity: 10, State: 02002/04/01 14:00:22.58 ods Unable to write to ListenOn connection '1433', loginname 'sa', hostname 'FONGYIUN'.2002/04/01 14:00:22.58 ods OS Error : 64, The specified network name is no longer available.2002/04/01 14:00:22.58 spid10 Error : 1608, Severity: 21, State: 22002/04/01 14:00:22.58 spid10 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information." |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-09 : 13:29:25
|
Two things to try. First is to have the network admin perform diagnostics on the SQL Server's network card, just to rule out the possibility of any trouble.The other thing is to see if some kind of packet sniffer or some other kind of network crawler is being run...even if your local network guy says there isn't. Some of these tools don't cause a lot of network traffic, but can cause the server to ping everything and eat up a lot of resources.The company I worked for had national and local level IT divisions, and the national people would do things that would totally FUBAR the network, without telling the local guys that they were doing it. We finally had to get the local market president to complain to the CIO of the company to get them to stop! |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-09 : 16:00:15
|
The third thing is to get mission critical DBs on 7.0 or better yet 2000. -Chad |
|
|
BC Khoo
Starting Member
1 Post |
Posted - 2002-04-09 : 22:49:04
|
Thanks for your advices. We change the server nic card already and the problem still happen. May be I will ask the network guy monitor the network traffic for a few days. I have a tot to upgrade to SQL2000 but I don't think we can just upgrade like that right? The applicaton have 800++ store procedure. Do we need to rewrite all of them? (sorry, i does not know how compatiable the application in SQL2000). What is the concern if we go for upgrading?thanks again for your valuable suggestion.. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-10 : 00:20:00
|
I would definitely do this in a test mode. I've done upgrades from 7.0 to 2000 without trouble, but I can't say that we're doing anything too fancy in our databases. I would expect that you'd be in really good shape, and not have to rewrite everything, but there will probably be a couple of issues. Do a Forum Search here on upgrading to 2000 because there are a couple of good threads with people's experiences.I have it on pretty good authority there will be an article coming out about one man's experiences, but you probably won't want to wait that long...------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
|