+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 24
MIS Systems Thread, I need to reboot the server once a week or Sims runs very slow or grinds to a halt. in Technical; Sims runs fine for about a week at one of my primary schools but then grinds to a halt. If ...
  1. #1

    Join Date
    Apr 2010
    Posts
    2,011
    Thank Post
    82
    Thanked 184 Times in 153 Posts
    Rep Power
    68

    I need to reboot the server once a week or Sims runs very slow or grinds to a halt.

    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.

    Server 2008r2
    SQL 2008r2 with SQL management Studio.

    What can i do or check so it keeps running.

    Thanks
    Last edited by edutech4schools; 14th November 2013 at 09:08 AM.

  2. #2

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,698
    Thank Post
    143
    Thanked 542 Times in 486 Posts
    Rep Power
    148
    How much RAM does it have/is allocated?

  3. #3

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,936
    Thank Post
    109
    Thanked 471 Times in 324 Posts
    Blog Entries
    2
    Rep Power
    266
    Quote Originally Posted by 3s-gtech View Post
    How much RAM does it have/is allocated?
    Good point @3s-gtech, if SQL is allowed to balloon it can result in a sluggish OS.

    Speeding up SIMS

  4. #4

    Join Date
    Apr 2010
    Posts
    2,011
    Thank Post
    82
    Thanked 184 Times in 153 Posts
    Rep Power
    68
    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.

  5. #5

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,241
    Thank Post
    239
    Thanked 1,567 Times in 1,249 Posts
    Rep Power
    339
    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.

  6. #6

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    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.

  7. #7

    Join Date
    Apr 2010
    Posts
    2,011
    Thank Post
    82
    Thanked 184 Times in 153 Posts
    Rep Power
    68
    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.

    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.
    Good idea. I will bash one together.

  8. #8

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,241
    Thank Post
    239
    Thanked 1,567 Times in 1,249 Posts
    Rep Power
    339
    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?

  9. #9

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,936
    Thank Post
    109
    Thanked 471 Times in 324 Posts
    Blog Entries
    2
    Rep Power
    266
    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

    http://technet.microsoft.com/en-us/l.../bb510493.aspx
    Last edited by jinnantonnixx; 14th November 2013 at 10:07 AM.

  10. #10

    Join Date
    Apr 2010
    Posts
    2,011
    Thank Post
    82
    Thanked 184 Times in 153 Posts
    Rep Power
    68
    Does this particular server have more roles installed than the other identical servers in your other schools?
    Same roles although they do run everything DC, DHCP etc so could do with more than 4gb anyway.

    Will run the scripts on Monday pm when I am at the school.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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....

  12. #12
    AButters's Avatar
    Join Date
    Feb 2012
    Location
    Wales
    Posts
    452
    Thank Post
    137
    Thanked 105 Times in 80 Posts
    Rep Power
    41
    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.

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    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.

  14. #14

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,936
    Thank Post
    109
    Thanked 471 Times in 324 Posts
    Blog Entries
    2
    Rep Power
    266
    Quote Originally Posted by matt40k View Post
    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.
    No, he's got the DeathStar edition.

  15. #15

    Join Date
    Sep 2010
    Posts
    543
    Thank Post
    26
    Thanked 60 Times in 56 Posts
    Rep Power
    19
    Quote Originally Posted by jinnantonnixx View Post
    No, he's got the DeathStar edition.

    Much LOL

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Very slow saving times to H: drive and other shared areas!
    By abillybob in forum Windows Server 2008 R2
    Replies: 28
    Last Post: 24th October 2013, 02:18 PM
  2. Replies: 4
    Last Post: 14th February 2010, 01:13 PM
  3. Server - where to put the fastest HDD?
    By CM786 in forum Hardware
    Replies: 14
    Last Post: 3rd April 2006, 11:06 PM
  4. Replies: 10
    Last Post: 10th October 2005, 06:46 PM
  5. Replies: 24
    Last Post: 6th September 2005, 12:26 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •