I have developed a booking system using Delphi that uses SQL 2005 as it's backend.
There are 6 users at different locations that use Remote Desktop to access the system.
Every day at roughly the same time the system seems to become very slow for all users. CPU usage becomes 100%.
If I open Task manager/Processes I see that there are approx 5 instances of bookingsystem.exe runnning. If there are 5 running then each of them has 20% of the CPU. I end one of them and then the remaining 4 share 25%. I end another and they then share 33% and then 2 share 50% and one has 100%. It doesn't matter in what order i end the processes it always does the same.
Once i have ended them all, people log back in and then everything is fine until the next day at about the same time.
I can't see any scheduled tasks, and ther's nothing in the event logs.
Has anyone got any idea what could be causing this? I don't know where to turn next in terms of diagnosing this.
Start Free Trial
