Just an update on this - the problem seems to be with the Sims Homepage if you are using the graphs (apparently attendance mainly). Nice to see they are on the ball as somebody at a local school here worked this out about 8 weeks ago!
SIMS Performance / Homepage Panels
We have recently been made aware of a small number of customers that have been experiencing slower than expected performance of their SIMS system. On investigation we have found a small number of cases where this has been caused by heavy usage of the SIMS Homepage panels across large numbers of staff. Many of the panels have automatic refreshing of data and therefore, if large numbers of users each have many panels setup for them then this could place a significantly higher load on the SQL Server than was the case before these panels were configured.
To help reduce any potential impacts from this, if you are experiencing performance issues we would recommend evaluating the number of SIMS Homepage panels in use by your staff and consider reducing their usage and number of automated refreshes.
We will be updating the Homepage panels in future releases of SIMS to allow more control over the refresh frequency hence reducing the potential load on the SQL Server
Technical Product Manager (SIMS)
My server running like crap since upgrade just thrown ram at it plus I spoke to sims today knowing there is memory leak for some and be fixed in March
Thank god I am not alone :)
Having the exact same issue. I have setup a new VM and installed the reindex patch and still seeing CPU spiking. Lets hope the March update fixes it.
I had to throw 10Gb of ram and 4 cpu threads at it! bene told leak and also increased module screens within SIMS
If you remove the graphs from the welcome page this is supposed to fix the probelm - i threw extra ram and cpu's at the machine to make it run better but its the graphs on the welcome that cause the problem
Can i ask how everyones is acting in regards to time taking saving entries? OR reading entries on SIMS?
Is it possible to turn the homepage graphs of globally. We are having a nightmare at the moment. Slow registers, reports, etc. After the first load the next request is quick. Restart sims and the back to slow again.
Anyone found a real answer to this
Just to add support, ours has been gradually getting worse and worse. The only thing that cured it for about a week was the housekeeping procedures that we have since been told not to run as they can ruin the data.
Don't think there is a global admin of the front page as this is what we asked for as soon as it was released and we were told it would be coming. Not heard anything since. As ever release something and then think about management after.
Routines | Homepage | group config
make a custom group with no panels or bare minimum. Then apply everyone to it.
Edit all other groups or make sure sure no-one is listed in them though i think it's supposed to autofill them in so best to edit out all. Though you may want some select users to keep some.
Then go into Routines | Homepage | lock config
Lockdown so no changes are allowed, and hopefully this will force what you want.
I think the caveat is that if they have already made their own custom ones it keeps them, or merges them with existing ones force by group config, though that's the case if you give them panels. If you force no panels, then it will hopefully turn them off.
There is a quick reference sheet somewhere that explains it all i think, but it's not in the documentation area of sims, so it might only be available as a download, will have to check later.
I have done lots of testing with various accounts new ones as well, making an account a domain admin still slow. Once the reports have loaded for the first time they next time they load quick. closing and restarting sims and back to square one. Capita must surley be looking at this! Well one would hope! Starting to get it in teh neck for SLT, been 2 weeks for me now.
I do have one user working on a laptop that has now issues at all.
I have found the problem that was causing our problems with SIMS.
Not profile problems, not SQL, not antivirus, not windows updates, not hardware, not lack of RAM
The problem was with the proxy exceptions in internet explorer. Our local network is in the range 10.80.*.*
As soon as I entered 10.* in the exceptions hay presto back to normal.
I need to make a change a couple of weeks ago where I removed the exception.
So now my question is why does SIMS need this entry? The initial start-up of SIMS was fine, just when the user needed to run reports or registers. Our DNS is tiptop, the connect.ini is correct.
There must be some underlying process that I do not understand
Might be worth a look for you guys!
Not 100%, but I am sure SIMS uses HTTP to deliver reports/documents.