• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • 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 JacksonCommented:
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 ZiaCommented:

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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