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?