+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, When should you move from SQL Express to Full SQL? in Technical; SIMS Server We have upgraded to Sql 2008 Express and SIMS runs slow. We have SIMS InTouch and although Capita ...
  1. #1

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,064
    Thank Post
    391
    Thanked 302 Times in 256 Posts
    Rep Power
    151

    When should you move from SQL Express to Full SQL?

    SIMS Server
    We have upgraded to Sql 2008 Express and SIMS runs slow. We have SIMS InTouch and although Capita say that doesnt have an impact on SIMS overall performance I am sure it has degraded since InTouch was installed.

    would it be beneficial to move from Sql Express to Sql Full? We have about 100 users and 800 students.

    The SIMS Server is currently 2003 SP2 with 4GB and I am planning to put 2008 R2 on over the summer and up the RAM to 16GB.

  2. #2

    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
    Yes, to utilise the RAM i think, and also if your db is large, you'll want this. 100 is a fair number of users to have.
    There is another thread with specific details on the differences and you can check with M$, but if you're a secondary, you should go Full, as you'll want to expand over time, you're already using an extra service in InTouch that will add data flow.

  3. #3

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,064
    Thank Post
    391
    Thanked 302 Times in 256 Posts
    Rep Power
    151
    If we go for Sql 2008 , should it be R2? Is that supported by Capita yet? Also for 100 users would a per processor licence be better or Server + CALs? I have no idea how much SQL Standard is for educational use as we have always used Express versions.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    My full we mean Microsoft SQL Server 2008 Standard edition (with SP2 applied). Pretty sure processor(s) license would be best for you.

  5. #5

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    What kind of disc have you got for the database? Is anything else on the server? What does performance monitor tell you? (look at things like the disk queue length)

    The full SQL server lets you use more RAM (1Gb limit on Express) so if you're running out of RAM then the full version will take advantage of what you've got without having to put in more RAM but if the disc is the bottleneck (and it often is!) then changing to full SQL or adding more RAM will be just throwing money away.

  6. #6
    Chris_'s Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    663
    Thank Post
    130
    Thanked 109 Times in 92 Posts
    Rep Power
    43
    To carry on from what others have said, SQL 2008 Express is also limited to only 1 processor so if you're using a server with multiple processors, SQL is only utilising one of them. 2008 Express is also limited to a database size of 4GB, 2008 R2 Express is limited to 10GB though.

  7. #7

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    617
    Thank Post
    94
    Thanked 128 Times in 99 Posts
    Rep Power
    66
    What srochford and chris_ said is spot on. I often find disk queue is an issue. Is this a physical server or a virtual server?

    Mic@Serco

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Good point, having separate discs for OS and Data helps alot and actually having SQL installed on the data drive\raid helps as well... not that I'm saying I've seen that happen...

  9. #9
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    62
    Yes you really need to upgrade if you are a Secondary School. The Express 1 CPU and 4GB RAM limit will be castrating the performance you could get.

    If you move to SQL2008 Standard and up the RAM in the server to 8 or 16GB you will see a massive performance increase as SQL will effectively load your SIMS database into RAM which is much faster than the hard drives.

    Butuz

  10. #10

    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
    Quote Originally Posted by fiza View Post
    If we go for Sql 2008 , should it be R2? Is that supported by Capita yet? Also for 100 users would a per processor licence be better or Server + CALs? I have no idea how much SQL Standard is for educational use as we have always used Express versions.
    Yes it is supported now.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Upgrade SQL 2008 Express to FULL 2008 R2 Standard
    By fiza in forum MIS Systems
    Replies: 9
    Last Post: 29th June 2013, 07:46 PM
  2. SQL 2008 Express
    By creese in forum MIS Systems
    Replies: 2
    Last Post: 7th July 2010, 12:19 PM
  3. Install SQL 2005 Full over 2005 Express (other instances)
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th April 2009, 03:19 PM
  4. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 05:43 PM
  5. SIMS SQL upgrade. To Express or not to Express?
    By woody in forum MIS Systems
    Replies: 5
    Last Post: 16th October 2007, 04:34 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
  •