Individual Report Processing Speed Issues
Am hoping someone maybe able to help with a problem that we are experiencing.
We are finding SIMS to be extremely slow in generating individual reports. Last year academic year we were looking at about 20 minutes to generate tracking grids for 30 students, this year we are talking upwards of 50 minutes for the same number of students on the same template.
Obviously we have applied the latests updates and we are using a temporary server for SIMS. We are currently going through a major building project that means we cannot use our normal server room. However looking at the server we are peaking at about 70% CPU at times but not constantly. We are peaking at 10gb out of 14gb of RAM. The only bottleneck appears to be the Hard Drives.
Now I know we are not exactly a small school ~ 2500 students with each year group being on average 350 students. This particular template will take nearly 11 hours on the above timings to generate to a PDF collector before I actually start to print.
We have spoken to SIMS but to be honest they were not much help and kept saying "well you are a large school", I thought I would ask the community here to see if what we were experiencing was normal.
Thanks for any help / advice
St. Georges Academy