Producing School Reports - Slow...
Just wondered if there was anyone who may have had the same issue as me with WCBS PASS whilst running reports.
Basically we have installed PASS this year, after months of agro, and constantly slow performance, I have moved PASS to a new server (4 x Quad Cores, 12GB RAM, 15k SAS drives, Server 2008R2, SQL 2008 Full Edition), but the same issue persists, when I run a report it can take between 1 minute and 6 seconds and 3 Minutes 16 Seconds to display a report for a relativley small bunch of students, on SIMS this would take seconds.
I have run a trace on the SQL server and run several index tuning tasks, there is still no difference. When running a trace the SQL transactions seem to come through in small, slow bursts from the main application, which i find concerning.
It is also worth noting that if you click on the application during the report building process the application will freeze and crash. (On both the old installation and the new installation)