SQL Server 2000 timeout connections on local server

Posted on 2007-10-09
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
    LVL 16

    Expert Comment

    select * from master..sysprocesses

    next time it starts bogging down.
    LVL 14

    Expert Comment

    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

    In server network utility  we have Named pipes + tcp/IP
    LVL 14

    Expert Comment

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

    Author Comment

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

    Accepted Solution

    Try downloading a trial copy of Spotlight on SQL Enterprise from - this will help with diagnosing the problem

    Author Comment

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now