+ 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,362
    Thank Post
    472
    Thanked 336 Times in 284 Posts
    Rep Power
    157

    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,956
    Thank Post
    771
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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,362
    Thank Post
    472
    Thanked 336 Times in 284 Posts
    Rep Power
    157
    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,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    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,159
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    125
    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
    734
    Thank Post
    142
    Thanked 125 Times in 105 Posts
    Rep Power
    46
    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
    636
    Thank Post
    100
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    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,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    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
    63
    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,956
    Thank Post
    771
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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, 08:46 PM
  2. SQL 2008 Express
    By creese in forum MIS Systems
    Replies: 2
    Last Post: 7th July 2010, 01: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, 04:19 PM
  4. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 06: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, 05: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
  •