• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

SQL Server 2000 hangs at certain time of day

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?

4 Solutions
Paul JacksonSoftware EngineerCommented:
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.

Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:

Please check the following for given time:

Event Log
Sql Server Log
Windows Task Manager
Sql Secheduler


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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
Eric3141Author Commented:

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.

Eric3141Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now