Sims Slow

[sunny88]

Hi, We recently installed a new server for a school. Since then they are complaining SIMS is slow.

Server is SQL 2022 and Server 2022 OS.

Now we had ESS on remote, they said all was fine.

 

I had SQL in 2012 Compatibility mode as per ESS request. Upon changing to 2022 Mode its significantly faster. Reports were taking 90 Seconds plus. Now they are 10 secs.

Ess recommend 2012 compatibility mode, but in our case this made it slow. Does anyone know why 2012 mode is recommended. Also why would doing something ESS don't recommend make it faster.

 

Now one issue that the school still find slow is loading Pupil details. Its taking a good 10 seconds. This is slow for the school. We have tried everything, Commanttimeouts in connect.ini. Reindex patches etc.

 

Are other schools mostly getting this time on pupil details. Its the only thing that is now slow on sims.