How much RAM does it have/is allocated?
Sims runs fine for about a week at one of my primary schools but then grinds to a halt. If I reboot the server everything is normal. This started to happen about a month ago but no major changes in that time.
SQL 2008r2 with SQL management Studio.
What can i do or check so it keeps running.
Last edited by edutech4schools; 14th November 2013 at 10:08 AM.
How much RAM does it have/is allocated?
I will check when I am next back at the school but think it is probably the same as the other primary school servers installed by the LA which have 4gb.
4GB of memory isn't unreasonable, but bumping it up to 8GB can make all the difference.
You could also create a batch file to run in the early hours of the morning to reset the SQL Service SIMS uses. This should buy you a lot of time.
IMHO with Sims I have always run on the theory M$ base OS recommendations 4GB + Size of the Database 2 x i.e if you DB is 2gb assign the server 8gb.
Is there any database maintenance plans I could run from Studio manager that would help?
Why would rebooting the server help Sims work for the following week?
I will look at getting more RAM but wonder why it is an issue at this school and not my other schools with same hardware, seeing as this school is one of my smallest with less on the server and less in Sims.
Good idea. I will bash one together.You could also create a batch file to run in the early hours of the morning to reset the SQL Service SIMS uses. This should buy you a lot of time.
I'd certainly check SQL is fully patched, but really (in my opinion) you're using a 64Bit OS with a 64Bit version of SQL - 4GB just isn't enough. 8GB-16GB is more realistic for this sort of setup.
Does this particular server have more roles installed than the other identical servers in your other schools?
Have you tried the memory checking scripts (mentioned in an earlier link)
Code:-- SQL Server 2008 and R2 Memory Related Queries -- Glenn Berry -- October 2010 -- http://glennberrysqlperformance.spaces.live.com/ -- Twitter: GlennAlanBerry -- Instance Level queries -- Good basic information about memory amounts and state (SQL 2008 and 2008 R2) SELECT total_physical_memory_kb, available_physical_memory_kb, total_page_file_kb, available_page_file_kb, system_memory_state_desc FROM sys.dm_os_sys_memory; -- You want to see "Available physical memory is high"
Code:-- SQL Server Process Address space info (SQL 2008 and 2008 R2) --(shows whether locked pages is enabled, among other things) SELECT physical_memory_in_use_kb,locked_page_allocations_kb, page_fault_count, memory_utilization_percentage, available_commit_limit_kb, process_physical_memory_low, process_virtual_memory_low FROM sys.dm_os_process_memory; -- You want to see 0 for process_physical_memory_low -- You want to see 0 for process_virtual_memory_low
Last edited by jinnantonnixx; 14th November 2013 at 11:07 AM.
Same roles although they do run everything DC, DHCP etc so could do with more than 4gb anyway.Does this particular server have more roles installed than the other identical servers in your other schools?
Will run the scripts on Monday pm when I am at the school.
Rebooting SIMS server is so last decade!
If it's multi-roled it could be anything causing it but SIMS suffering.
I'd look at RAM and page file usage, sims ldf size, the event log....
Agree you need more RAM. 2008 will use up to 2GB just for the O/S and if your SIMS Database is 1GB or more then you do not have much left over.
8GB would be ideal unless your database is over 4GB in which case you'd need 12 or 16GB.
Remember it's a primary school, it's only got SQL Express, which will only use 1 GB ram. So anything more then 8GB will most likely be wasted. Also worth check DISC IO - if you go into performance monitor then look at the disc queue length for reads and writes. Could be SQL installed to C: rather then another disc.
There are currently 1 users browsing this thread. (0 members and 1 guests)