[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Server 2000 timeout connections on local server

Posted on 2007-10-09
Medium Priority
Last Modified: 2013-12-01
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?
Question by:zperetz
  • 3
  • 3
LVL 16

Expert Comment

ID: 20041152
select * from master..sysprocesses

next time it starts bogging down.
LVL 14

Expert Comment

ID: 20041355
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 Comment

ID: 20055465
In server network utility  we have Named pipes + tcp/IP
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

LVL 14

Expert Comment

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

Author Comment

ID: 20165517
all connection use ADO NET.
 some with sql server IP in connection strings
some with computer name in connection strings
LVL 14

Accepted Solution

twoboats earned 1500 total points
ID: 20168261
Try downloading a trial copy of Spotlight on SQL Enterprise from Quest.com - this will help with diagnosing the problem

Author Comment

ID: 20170904
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

867 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