[sims] SIMS crashing when using Attendance

[edsa]

Hi all

 

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

 

8GB RAM

 

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.

 

Many thanks

 

Eddie

[bossman]

@edsa:

 

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.

 

Good luck

[matt40k]

Spec of attendance workstation?

[bossman]

@matt40k:

 

I forgot to ask that all our workstations are 4Gb Ram with dual core intel processors.

[vikpaw]

Is this the same thing you were getting @bossman ? Using Edit Marks to edit large groups..?

Memory must defo be the issue.

[maestromasada]

Have you tried to save the attendance data on the server itself? How many switches/speed goes from the server to the workstation?

[bossman]

Is this the same thing you were getting @bossman ? Using Edit Marks to edit large groups..?

Memory must defo be the issue.

 

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.

 

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?

[vikpaw]

@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.

[bossman]

@vikpaw:

 

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?

[vikpaw]

@bossman - check out the roaming profiles / office 2010 threads