PARS and SIMS extremely slow when saving and opening data
I have had lots of reports of SIMS and PARS running slowly. One example I have seen myself is that sometimes when a teacher tries to save a register on PARS, it takes a long time. I've seen it take about 7 minutes and I'm told that it's taken over 25 minutes before. It used to take a couple of seconds...
The person who normally deals with SIMS and PARS is not well at the moment and won't be back in work for a while.
After looking at some other posts on this forum I have tried watching the Activity Monitor for our database, but I don't really know what I'm watching to be honest. I have seen the "Waiting Tasks" reach over 1600, don't know if that is normal or not. I have attached a couple of screen shots of the activity monitor with the processes list sorted by the "Block By" column. I don't know if anybody was stuck on saving when these screenshots were taken.
We are currently running SQL 2005 Enterprise and getting ready to upgrade to 2008.
Attachment 9023Attachment 9024Attachment 9025