Hello all!
i am having serious problems with my sims performance, i have tried to rectify and make it run quick by doing the following;
applied 3 patches from Capita help desk
capped the server ram at 20gb but made it dynamic
put the processors at 6 (advice from help desk as over spec apparently can make it run slower, it was previously runing 10)
capped the sql instance of sims to 16gb
shrunk all database files (the sims files went from 10.5gb to 7.5gb)
archived attendance marks
deleted over 300 assessment templates
i really do not know what else can be done, any ideas ?
**server 2012r2
**SQL 2014