SQL Server 2000 hangs at certain time of day

Posted on 2011-05-05
Last Modified: 2012-05-11
We have an old ASP application that has SQL Server 2000 backend.  This runs at 15 locations (each with their own SQL Server 2000 db backend) but only one of them has this problem:

The users report that the web app runs acceptably well until about 2:00 in the afternoon when it becomes very sluggish.  From 2:00 to about 3:30 it runs very slow then suddenly runs fine again.  I have checked the db and there are no scheduled jobs that run during this time.  We have replication setup but it runs throughout the day including the times when they say the web app runs fine.

Ideas on what to check?

Question by:Eric3141
    LVL 29

    Assisted Solution

    by:Paul Jackson
    The first thing to do would be to look in SQL Enterprise Manager when the problem occurs and examine the processes running against the database. This is found in Management area.
    LVL 16

    Assisted Solution

    by:Imran Javed Zia

    Please check the following for given time:

    Event Log
    Sql Server Log
    Windows Task Manager
    Sql Secheduler

    LVL 3

    Assisted Solution


    Check for the below.

    1) SQL Server Log
    2) check for any long running queries.
    App team: has to recheck their query
    DBA: check for the index and statistics, check locks and block duration
    3) use sp_who3 to check for any thing worng on the server. You can sp_who3 and create a job to save the result in a text file. It will help you understand the real time problem
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    I've requested that this question be deleted for the following reason:

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
    LVL 2

    Accepted Solution


    I was reassigned to another project / problem so did not have time to try any of the solutions offered.  I did not know how to handle that at the time.  Now I realize that I can award points to all who replied and just not add the solution to the knowledge base.  Please cancell the deletion so I may do that.

    LVL 2

    Author Closing Comment

    I was reassigned to another project and did not know how to handle that.  Did not have a chance to try the solutions offered.  I have accepted the solutions offered and equally divided the points -- I felt that all should be rewarded for trying to help.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    732 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

    19 Experts available now in Live!

    Get 1:1 Help Now