We have a database called Universe that runs on a Windows 2003 server. Most of the day everything runs fine and we have no problems. Actually most of the time period it works fine. We have seen some issues in the past where the server became unresponsive so we installed an application called Process Lasso to help manage the cpu and keep things running.
This software has helped us a lot, however, the last couple of weeks we have been having issues again. We use telnet to connect to our database and for a period of about 5 minutes it will become unresponsive. We can remote to the server but by the time we get on the server, whatever the problem was no longer exists and everything is back to normal.
One other interesting note. I was remoted into the server yesterday morning. I opened windows explorer and copied and renamed a fairly large directory. When I did this the system became unresponsive and I could not access it from telnet. Is this normal? It even happens on our test machine as I was able to reproduce the problem there. This makes me wonder what could be going on in the background causing this issue.
How would you attach this to determine what is going on? Keep in mind I'm just a programmer but kind of stuck figuring this thing out.