+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SQL 2008 Express or Standard? in Technical; Our LA have just contacted me about the migration and I'm wondering, which version of SQL would be better to ...
  1. #1

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,161
    Thank Post
    403
    Thanked 623 Times in 569 Posts
    Rep Power
    181

    SQL 2008 Express or Standard?

    Our LA have just contacted me about the migration and I'm wondering, which version of SQL would be better to use? They use Express (Free) but I've read this on the forum:

    Express will run it (unless your DB is bigger than 4GB) but may slow down under the additional user load as it is limited to 1GB of cache memory and one CPU core


    That would suggest that the Standard edition is better? We're a secondary school with approximately 10 users always using SIMS.

    Any advice would be appreciated!

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,255
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    I wouldn't go for express in a secondary. It's okay for primary phase.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    If you're using lesson monitor, def get standard.

    Just remember, it's really easy to upgrade from express to standard in SQL2008.

  4. #4

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    Since you say there are only 10 people using SIMS I'd suggest you probably aren't using Lesson Monitor. In which case use Express and see how you go (since it's free). If you find access is slow and/or your server is not coping then upgrade. No point shelling out cash if you don't need to.

  5. #5

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,332
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I agree with timzin but would encourage you to look at how you could get more benefit from SIMS by putting it in the classroom.

  6. #6


    Join Date
    Jul 2007
    Location
    Rural heck
    Posts
    2,662
    Thank Post
    120
    Thanked 434 Times in 353 Posts
    Rep Power
    126
    And you need SQL 2008, NOT SQL 2008 r2.

    I know of a school who ended up rebuilding their SIMS server after making that mistake.

SHARE:
+ Post New Thread

Similar Threads

  1. SQL 2008 Express
    By creese in forum MIS Systems
    Replies: 2
    Last Post: 7th July 2010, 12:19 PM
  2. [For Sale] SQL 2008 Standard plus 5 User Cals
    By FN-GM in forum Classified Adverts
    Replies: 4
    Last Post: 9th May 2010, 09:37 PM
  3. Replies: 4
    Last Post: 22nd March 2010, 08:32 PM
  4. SQL 2008 express
    By Boon72 in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 3rd February 2010, 10:55 AM
  5. SQL Server Express 2008
    By damienharrison in forum Windows Vista
    Replies: 6
    Last Post: 13th March 2009, 11:26 AM

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
  •