+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, New Sims Server - A Few questions... in Technical; Right so we are having issues with our Sims server (when we change passwords or create new users it times ...
  1. #1

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39

    New Sims Server - A Few questions...

    Right so we are having issues with our Sims server (when we change passwords or create new users it times out and stops

    alot of users logging on until we dettach and reattach the database).

    We have been told by our Sims support provider that our server is to slow / old and needs replacing to fix the issue.

    We have a school with 1100 Students and 100 Staff. The staff use Sims for registration in their classes so maximum Sims

    logins at the same time would be about 70+.

    Present Server

    Dell PowerEdge 4600
    2 x Xeon 2.4Ghz
    4Gb Ram
    Windows 2000
    SQL Server 2005 Express
    No Raid Ultra320 SCSI HD's (With plenty of space)

    So I am looking to purchase a new server, new os and new sql software and I have a few questions

    1) Will this server spec be ok? The server will only be running Sims and the document server.

    Dell PE T300 Quad Core Xeon X5460 (3.16GHz,2x6MB, 1333MHz FSB)
    12GB DDR2 667MHz Memory - 1 CPU (6x2GB dual rank DIMMs)
    C4 SAS/SATA cabled, RAID 1, Add-in SAS6iR Cntrl, 2 Hard Drives
    SAS 6i/R Internal Controller RAID PCIe
    146 GB SAS 15k 3.5" HD

    2) Which OS?

    Windows 2003 32 or 64Bit? Standard or Enterprise? With or Without HyperV?
    Windows 2008 32 or 64Bit? Standard or Enterprise? With or Without HyperV?

    (I'm guessing 64Bit to see the 12Gb of ram - will there be any issues running Sims on 64Bit?)

    3) Which SQL Server Software?

    Should I buy Single processor License of SQL Server 2008 and just use SQL Server 2005 until Sims switch to SQL2008

    support soon which will then allow me switch quickly (I beleive the licensing allows backward use?)

    Should I get the standard or enterprise version of SQL Server?

    4) Licensing CALS?

    If I have an SQL Server processor License will I still require Windows CALS for them to connect to the database?

    Another Domain Controller will authenticate their permissions to the Sims Server.
    The Sims SQL database will authenticate there access to sims itself.

    Sorry for the long post... thanks for any help anyone can provide

  2. #2

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    I can help with point 4: if you have a processor license you do not need additional CALS. When we were licensing 2005 I think the break even point was around 40 users below that the per seat license and CALS were a cheaper option.

    As SIMS is moving to SQLServer 2008 from October this would be the obvious option to go for - by the time you're up and running migration will probably be under way

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,410
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Just heard of a school going Windows 2008 x64 with full MS SQL 2005 x64, lovely server. Works alright.

    Make sure you get SQL 2008 with downgrade rights. SQL 2008 comes out in Oct, it seems alright, but it's aways good to wait a while.

    CPU license isn't too bad if you have a 1 cpu system. I think it's like £20 per client otherwise.

    Don't worry about dual cpu system, if it's a dedicated SIMS server, ram is king.

    Is the LA\Capita installing it? If you're moving SIMS make sure you have the latest SIMSinst.

  4. #4

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Quote Originally Posted by Hecate View Post
    I can help with point 4: if you have a processor license you do not need additional CALS. When we were licensing 2005 I think the break even point was around 40 users below that the per seat license and CALS were a cheaper option.

    As SIMS is moving to SQLServer 2008 from October this would be the obvious option to go for - by the time you're up and running migration will probably be under way
    I understand about the Per Processor SQL Server software. (I will be purchasing the SQL 1 Processor License to remove the need for SQL CALS)

    I was wondering whether I need Windows Server CALS for the clients to connect to the server to use the SIMS SQL database?

  5. #5

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Quote Originally Posted by matt40k View Post
    Is the LA\Capita installing it? If you're moving SIMS make sure you have the latest SIMSinst.
    Hehe no the LEA isnt installing it... I wouldnt trust them to change a toner never mind install a server...

    I'm just purchasing the system from Dell and doing everything else myself

  6. #6

    Join Date
    Dec 2005
    Posts
    536
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Well scrap all that for the time being....

    While researching the install of a new Sims server I read up on a few performance tweaks for Sims.

    One related to the Reason 0 problem and the fact we were running SQL 2005 Express (limited to 1gb ram).

    I just upgraded the server to SQL 2005 Standard (1 Processor License) and adjusted the bootin to allow applications 3Gb of memory and now I can create users and change passwords without timeouts and without it locking the database and cuasing Reason 0 Errors and lots of people not logging on.

    Not as nice a fix as a new speedy server but it should hopefully last until BSF borgs take over

    Thank you everyone for the help you posted.

    PS.(Thinking out loud) I also wonder if SQL Express's limit of connections has anything to do with timeouts?

SHARE:
+ Post New Thread

Similar Threads

  1. Server questions
    By LeMarchand in forum Windows Server 2000/2003
    Replies: 10
    Last Post: 29th July 2009, 01:34 PM
  2. SIMS Performance Reporting Questions
    By DBMan in forum MIS Systems
    Replies: 21
    Last Post: 22nd June 2009, 10:28 AM
  3. .sch.uk domain server questions..anyone?
    By Sirbendy in forum Web Development
    Replies: 30
    Last Post: 4th January 2008, 01:38 PM
  4. DNS Server Questions
    By FN-GM in forum Windows
    Replies: 2
    Last Post: 26th November 2007, 09:02 AM
  5. Server 2K3 - Few questions
    By googlemad in forum Windows
    Replies: 6
    Last Post: 20th August 2007, 07:01 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
  •