+ 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,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84

    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,927
    Thank Post
    155
    Thanked 605 Times in 544 Posts
    Rep Power
    160
    How much RAM does it have/is allocated?

  3. #3

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,028
    Thank Post
    120
    Thanked 513 Times in 347 Posts
    Blog Entries
    2
    Rep Power
    288
    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,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84
    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,266
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    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,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    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,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84
    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,266
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    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
    2,028
    Thank Post
    120
    Thanked 513 Times in 347 Posts
    Blog Entries
    2
    Rep Power
    288
    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,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84
    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,788
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    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
    498
    Thank Post
    156
    Thanked 110 Times in 85 Posts
    Rep Power
    43
    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,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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
    2,028
    Thank Post
    120
    Thanked 513 Times in 347 Posts
    Blog Entries
    2
    Rep Power
    288
    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
    617
    Thank Post
    26
    Thanked 71 Times in 66 Posts
    Rep Power
    21
    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
  •