+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, SIMS server issues in Technical; Hi all, We are a large school with 2000+ students and we are getting alot of slowdown on the SIMS ...
  1. #1

    Join Date
    Feb 2012
    Location
    Kent
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS server issues

    Hi all,

    We are a large school with 2000+ students and we are getting alot of slowdown on the SIMS server

    Just wondered if any of you guys run a similar site, if so, what server hardware do you use, what OS and version of SQL are you running?

    How do you find it?

    Thanks

    Andy

  2. #2
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,193
    Thank Post
    134
    Thanked 340 Times in 287 Posts
    Rep Power
    84
    Could we get a bit of an idea as to your current server spec as well?

  3. #3

    Join Date
    Feb 2012
    Location
    Kent
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi,

    We currently run a HP Proliant DL160 G6 with an intel Xeon 5650 2.66Ghz processor and 8GB RAM. we use Server 2003 and SQL2008.

    Thanks

  4. #4
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,193
    Thank Post
    134
    Thanked 340 Times in 287 Posts
    Rep Power
    84
    What is your Hard Drive config like as well - any RAID cache?

  5. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,841
    Thank Post
    876
    Thanked 1,679 Times in 1,459 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by Orbit1705 View Post
    Hi,

    We currently run a HP Proliant DL160 G6 with an intel Xeon 5650 2.66Ghz processor and 8GB RAM. we use Server 2003 and SQL2008.

    Thanks
    Is that server 2003 x64?

  6. #6

    Join Date
    Feb 2012
    Location
    Kent
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Not sure what RAID setup it is, i will check.

  7. #7

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Specs aren't everything, it's best to take time and configure the server according to best practices.

    In the first instance though, check out Activity Monitor from SQL Manager (Right-click the server>Activity Monitor). This is an excellent place to start. If your lucky, something will jump out.

    Key things to check are Processes, also check if you can see anything under 'Block by'. Look at 'Recent Expensive Queries', this might shed some light on what's making your server busy.
    Last edited by jinnantonnixx; 1st May 2012 at 03:47 PM.

  8. #8

    Join Date
    Feb 2012
    Location
    Kent
    Posts
    6
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Server 2003 32

  9. #9
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    929
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    93
    Quote Originally Posted by Orbit1705 View Post
    Server 2003 32
    which version of server cause unless it is enterprise you are only ever going to be using 4 gb of that Ram

  10. #10
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    929
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    93
    take a look at the resources and see how much memory is being used by SQL

  11. #11

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    I think we all agree you're hampering yourself with an old 32 bit OS.

  12. #12

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,841
    Thank Post
    876
    Thanked 1,679 Times in 1,459 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by Mcshammer_dj View Post
    which version of server cause unless it is enterprise you are only ever going to be using 4 gb of that Ram
    Even then its still not as good as it would be on x64

  13. #13
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    929
    Thank Post
    35
    Thanked 160 Times in 129 Posts
    Rep Power
    93
    Quote Originally Posted by FN-GM View Post
    Even then its still not as good as it would be on x64
    agreed

    Ideally can you let us also know what version of SQL you are using and what service pack level

    In Sims what products are being used ie Lesson Monitor, Discover etc and what other roles does that server have

  14. #14

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,841
    Thank Post
    876
    Thanked 1,679 Times in 1,459 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by Mcshammer_dj View Post
    agreed

    Ideally can you let us also know what version of SQL you are using and what service pack level

    In Sims what products are being used ie Lesson Monitor, Discover etc and what other roles does that server have
    Well he will be running a x32 version of SQL so its pointless having 8GB RAM

    In a nutshell my advice would be to migrate to Server 2008 R2 with x64 SQL

  15. #15

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,078
    Thank Post
    853
    Thanked 2,677 Times in 2,271 Posts
    Blog Entries
    9
    Rep Power
    769
    Quote Originally Posted by FN-GM View Post
    Well he will be running a x32 version of SQL so its pointless having 8GB RAM

    In a nutshell my advice would be to migrate to Server 2008 R2 with x64 SQL
    Not entirely pointless if it is server enterprise it will use PAE to split up system memory into pages and then it is only each process that is limited to 4GB so each SQL instance could use a whole 4GB and if there are multiple instances/databases each can use this. The issue is that then the process will still have a hard limit and also be spread across two data pages meaning a context switch to get across it which is going to add latency and complexity for no reason.

    In short I agree, go 64bit, it is designed for this kind of thing and there is not even a current Windows Server OS that supports 32bit and there hasn't been for a couple of years now. The last 32bit version was of Server 2008 R1 and that was only recommended for testing not production, that was five years ago.

SHARE:
+ Post New Thread

Similar Threads

  1. PERC 5/i Battery Issue vs. SIMS Server. Eek!
    By Gongalong in forum Hardware
    Replies: 3
    Last Post: 16th December 2011, 02:17 PM
  2. [SIMS] SIMs Server Migration - Documents Server Issue
    By Andynonymous in forum MIS Systems
    Replies: 34
    Last Post: 29th May 2011, 07:16 AM
  3. [SIMS] SIMS Server query
    By Cache in forum MIS Systems
    Replies: 8
    Last Post: 23rd January 2011, 02:30 PM
  4. [SIMS] SIMS server reducancy
    By Newton in forum MIS Systems
    Replies: 9
    Last Post: 13th January 2011, 09:08 PM
  5. Sims installation issue on server
    By Avalon in forum MIS Systems
    Replies: 2
    Last Post: 17th October 2009, 09:15 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
  •