MIS Systems Thread, SIMS crashing when using Attendance in Technical; Hi all
We have a problem at the moment with SIMS crashing. The crash happens when our attendance officer tries ...
16th September 2011, 02:52 PM #1
- Rep Power
SIMS crashing when using Attendance
We have a problem at the moment with SIMS crashing. The crash happens when our attendance officer tries to save whole year groups data in Attendance. The error recieved when trying to save is "system out of memory". Our SIMS server has the following spec
Intel Xeon E5405 2Ghz
600GB HDD space
SQL Express 2008
I was going to upgrade to the full version of SQL Server as it can address more memory, but I was looking for other opinions on this before I upgrade.
16th September 2011, 03:02 PM #2
You hit the nail on the head, I would definitely do the upgrade.
Also look at cleaning up the database using the tools from within Sims as this can have an impact on use.
Once upgraded to Full SQL you can run the diagnostic tools to streamline your databases also.
16th September 2011, 03:27 PM #3
Spec of attendance workstation?
16th September 2011, 04:09 PM #4
I forgot to ask that all our workstations are 4Gb Ram with dual core intel processors.
17th September 2011, 07:30 AM #5
Is this the same thing you were getting @bossman ? Using Edit Marks to edit large groups..?
Memory must defo be the issue.
17th September 2011, 12:53 PM #6
- Rep Power
Have you tried to save the attendance data on the server itself? How many switches/speed goes from the server to the workstation?
17th September 2011, 07:06 PM #7
No it was the attendance officer who thought it was running slow but in actual fact she was trying to edit marks whole school so imagine the amount of data which has to be written backwards and forwards to both SQL and the memory on the client.
Originally Posted by vikpaw
Its better to use the editing feature in groups, registration groups and individuals which works very fast indeed (matter of 3 - 5 seconds) against pulling up the whole school data (just over a minute)
Thanks for the thoughts though Vic, things going well your end?
18th September 2011, 11:53 AM #8
@bossman - yep, i think that is the same as for the OP, the attendance office is editing marks for a whole school group. I think yours went slow as plenty of memory whereas on express it just conks out!
We're good here apart from issues with Office 2010 and anything that needs to use a Word Template - just going over recent threads here and on SupportNet.
18th September 2011, 10:10 PM #9
Just built the package recently, have ran it on test machines, will be testing out next week on selected user workstations i.e. Data manager, Office admin and PLO admin who all use office within Sims.net so should have a good cross selection before whole school deployment.
What problems are you having?
19th September 2011, 07:25 AM #10
@bossman - check out the roaming profiles / office 2010 threads
By Rawns in forum MIS Systems
Last Post: 31st January 2012, 09:22 PM
By 3s-gtech in forum MIS Systems
Last Post: 21st July 2010, 11:03 AM
By RSoP_Robbers in forum MIS Systems
Last Post: 1st July 2010, 08:52 AM
By Oops_my_bad in forum MIS Systems
Last Post: 6th February 2009, 07:15 PM
By Liam in forum How do you do....it?
Last Post: 11th February 2008, 04:19 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)