+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Difference between SQL versions in Technical; ...
  1. #1

    Join Date
    Apr 2010
    Posts
    2,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84

    Difference between SQL versions

    I am going to move my school over to Server 2008 from 2003 and also need to upgrade SQL. Our LEA have lots of different versions and I need some help deciding which to get.

    Currently they have SQL server 2005
    The school is a small primary single server setup.

    The LEA offer
    SQL Server Standard Edition 2008 English Licence 1 Processor at over £800
    SQL Server Standard Edition 2008 English Licence at over £100
    SQL Server Workgroup Edition 2008 - including 5 CALís at over £100


    Also do these come in both 32bit and 64bit together?

    Thanks for taking the time to help.

  2. #2
    TheLibrarian
    Guest
    Without knowing how many connections / CALs you need it's not really possible to give you much help.

    You have to ensure that you aren't multiplexing CAL's too. Or at least last time I looked at SQL licensing you weren't allowed to multiplex them.

  3. Thanks to TheLibrarian from:

    torledo (28th May 2010)

  4. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Personally, I'd go for Processor licenses (1 per physical processor in the server). Then you don't need CALs - but this depends on the number of CALs you'd need. The normal way to do it is figure out which would be cheaper overall. A couple of processor licenses, or a server license plus required CALs. Also, go for Standard edition, as 'Workgroup' has a limit of 4GB RAM.

  5. Thanks to localzuk from:

    torledo (28th May 2010)

  6. #4
    TheLibrarian
    Guest
    Quote Originally Posted by localzuk View Post
    Personally, I'd go for Processor licenses (1 per physical processor in the server). Then you don't need CALs - but this depends on the number of CALs you'd need. The normal way to do it is figure out which would be cheaper overall. A couple of processor licenses, or a server license plus required CALs. Also, go for Standard edition, as 'Workgroup' has a limit of 4GB RAM.
    As a large seconday school, we go for the processor licenses too, 64Bit Enterprise (at least I think it's Enterprise) so that we can give SQL ~10Gb of RAM.

    However it may not be the best choice for a small primary.

  7. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Quote Originally Posted by TheLibrarian View Post
    As a large seconday school, we go for the processor licenses too, 64Bit Enterprise (at least I think it's Enterprise) so that we can give SQL ~10Gb of RAM.

    However it may not be the best choice for a small primary.
    64Bit standard can handle 10GB RAM. The memory limit only exists on Workgroup (4GB) and Express (1GB). The rest are limited only by the memory limit of the server it runs on.

  8. #6
    TheLibrarian
    Guest
    Quote Originally Posted by localzuk View Post
    64Bit standard can handle 10GB RAM. The memory limit only exists on Workgroup (4GB) and Express (1GB). The rest are limited only by the memory limit of the server it runs on.
    AFAIK some of the programmers here use the extra features in the Enterprise version - I'm not one of them so I'm not sure.

  9. #7

    Join Date
    Apr 2010
    Posts
    2,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84
    Odd my last post didnt show up.

    Sims is only used by the office so we would have a max of 4 users.

  10. #8
    TheLibrarian
    Guest
    Quote Originally Posted by edutech4schools View Post
    Odd my last post didnt show up.

    Sims is only used by the office so we would have a max of 4 users.
    Well, if you max at 4 users your third option would be the one to go for - server and 5 CAL's, it may be worth a word with the HT (or whoever) to make sure that there aren't any plans to increase the number of SIMS users.

    You could go for the second option and add CAL's so that you could go over the 4Gb limit, but you'd have to decide if that was likely in the forseeable future.

  11. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,358
    Thank Post
    36
    Thanked 363 Times in 248 Posts
    Rep Power
    81
    SQL Express is free and should be fine for 4 users.

  12. #10

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    Quote Originally Posted by PhilNeal View Post
    SQL Express is free and should be fine for 4 users.
    We use sql express for about 200 users atm (and yes its veryyyy slow but predates me) we are upgrading to SQL 2008 standard edition next week!

  13. #11

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Quote Originally Posted by glennda View Post
    We use sql express for about 200 users atm (and yes its veryyyy slow but predates me) we are upgrading to SQL 2008 standard edition next week!
    Wow. That's pretty impressive. We have about 30 users on a time here and there's many complaints of slowness. 200 must be like waiting for a rock to erode...

  14. #12

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    Quote Originally Posted by localzuk View Post
    Wow. That's pretty impressive. We have about 30 users on a time here and there's many complaints of slowness. 200 must be like waiting for a rock to erode...
    it took me about 9 mins to login earlier! tbh it vaires between 140-200 depending on times of day etc. it goes really slow when reports are being run. the database is also around the size limit with sql express!

SHARE:
+ Post New Thread

Similar Threads

  1. [Joke] What Is The Difference...
    By DaveP in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 1st December 2009, 09:58 AM
  2. VMWare versions
    By cookie_monster in forum Thin Client and Virtual Machines
    Replies: 8
    Last Post: 19th June 2008, 05:48 PM
  3. [Joke] What's the difference between
    By CHR1S in forum Jokes/Interweb Things
    Replies: 7
    Last Post: 15th April 2008, 10:14 PM
  4. What do all the different versions of Vista do
    By SimpleSi in forum Windows Vista
    Replies: 14
    Last Post: 7th April 2008, 05:52 PM
  5. Office versions
    By JonR in forum How do you do....it?
    Replies: 4
    Last Post: 11th January 2008, 09:48 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
  •