SIMS Server sort slowed down to a crawl
Got an issue with our SIMS Server; got reports of our AIM High reporting system running really slowly today, and it was. I looked at the CPU Useage, and although a little 'spikey' this morning on the CPU, everything else seemed quite normal. So, I've restarted the firebirdsql service that this uses and that seems to have got things running again.
SIMS itself seems to be running ok; I can look up classes, pupils with no noticeable loss in speed (although seemed longer to start SIMS that normal) and I've not had complaints with regard to SIMS.
But, things don't seem right with the server. It's a Virtual Server running on XenServer and has been chugging away quite happily for a while now. I noticed that the nightly backup of the server seemed to take an age, a lot longer than normal. I tried emptying out a few backup directories, and this seem to take a long time as well. It feels sluggish on the remote desktop connection.
I'm planning on doing a server restart, but thought I'd do a quick and dirty backup with dbattach before doing a restart, however, this seems to be taking an absolute age. It's created the .bak file for the SIMS, but is stuck on Not Responding (for the last 30 minutes now).
The XenServer is not reporting any problems, and two other VM on this host are running quite happily, I've been moving around a few large files on these with no issues.. No lights are on the server itself to indicate a disk problem.
Any ideas? Tad worried to say the least.