We help IT Professionals succeed at work.

SQL Server 2000 timeout connections on local server

741 Views
Last Modified: 2013-12-01
Hallo!
We have two machin servers running win 2003.
One run's SQL Server 2000 + Server App, the other is our web server running IIS 6
From time to time seems that sql server stops responding to requests from both servers. (once a week or less if load is high)
Restart sql does not solve the problem, no events on windows logs, no problems on sql profiler, no system apparent problems on common perfmon  counters.
ani sugestions?
Comment
Watch Question

select * from master..sysprocesses

next time it starts bogging down.

Commented:
Have seen SQL 2000 not able to respond to connection requests when it's marshalling lots of data to send back to clients.

What network protocol are you using?

Author

Commented:
In server network utility  we have Named pipes + tcp/IP

Commented:
Okay - and are the clients set to use named pipes or tcpip?

Author

Commented:
all connection use ADO NET.
 some with sql server IP in connection strings
some with computer name in connection strings
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
OK,
Now we know quite for shure that its not an sql server problem.
since 1. IM responds ok
2. app log dont indicate sql query time out
3. moreover vb6 apps work fine!
thanks to all the responders
im moving the question to the NET zone

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.