+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS SQL upgrade. To Express or not to Express? in Technical; Sorry for yet another SIMS SQL upgrade question, but currently we are running MSDE 2000 like most other schools. With ...
  1. #1
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    624
    Thank Post
    3
    Thanked 21 Times in 17 Posts
    Rep Power
    24

    SIMS SQL upgrade. To Express or not to Express?

    Sorry for yet another SIMS SQL upgrade question, but

    currently we are running MSDE 2000 like most other schools. With the pending upgrade to 2005, we have the option of going full blown SQL2005.

    What if any benefits are there to diong this? I know that the max DB size on express is now 4GB. Our current Sims DB is just over 1GB. What's the chances of it growing beyond 4GB? And are there any speed / backup advantages to the full version that are worth the £1200 that it will cost us?

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183

    Re: SIMS SQL upgrade. To Express or not to Express?

    I am no database guru but I would have thought that SQL 2005 Express would be sufficient if MSDE is working admirably.

    If your DB does suddenly grow by a huge amount you can always export the database, uninstall Express, install a 'better' version and add the DB back in.

  3. #3

    Join Date
    Oct 2007
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL upgrade. To Express or not to Express?

    £1200 seems very expensive we have just been quoted about £140 plus Cals @ £13 each that is for standard version, but there is no reason for enterprise for a sims database, but enterprise would be about £1200

  4. #4
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    893
    Thank Post
    70
    Thanked 85 Times in 70 Posts
    Rep Power
    33

    Re: SIMS SQL upgrade. To Express or not to Express?

    Database size aside, I think there's a command line to determine whether SQL performance is being throttled by the performance limiter (in MSDE at least).

    As for licensing, it will depend upon the number of processors you have in the server and the number of clients which will determine the most appropriate licensing model. Eg if you have 1 processor in the server and >50 clients, then per processor licensing will probably be more cost effective.

  5. #5
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    624
    Thank Post
    3
    Thanked 21 Times in 17 Posts
    Rep Power
    24

    Re: SIMS SQL upgrade. To Express or not to Express?

    Ramesys who we normally get our licensing from quote £199 for the server licensing and £13.50 per client. We would need around 80 CALS so that's where the price comes from (rounded down .

    They don't have anything on their website about 'per processor' licenses, but I could have missed them. Our server has a single processor.

    Anyway, I think I have come to the conclusion that as Ric says, I've never noticed any performance issues detrimental to the running of SIMS.

    Our school closes in a few years to be amalgamated into an academy so probably not worth wasting the money on. Maybe the bursar will buy me a shiny new laptop instead??? (Yeah right!)

    Think I will go express and I can always upgrade later

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367

    Re: SIMS SQL upgrade. To Express or not to Express?

    I'm getting a per processor licence from Ramesys.
    It's costing £655 and i have two proc's so its £1310 in total.
    I believe that is for the standard edition.

    We considered CALs but we needed 70 + spares in addition to the 100 bought last year, so the difference was an extra few hundred to go for processor licence which makes sense as we get to leverage the extra processor power now.

    Haven't heard back from Ramesys so better chase them up as installation is set for Monday in Term 1 holiday by the estimable Capita.ICT
    )
    Last edited by vikpaw; 13th March 2008 at 05:09 PM.



SHARE:
+ Post New Thread

Similar Threads

  1. VS 2K8 Express Editions
    By PiqueABoo in forum Coding
    Replies: 1
    Last Post: 26th November 2007, 12:40 AM
  2. Smoothwall Express Error
    By netadmin in forum *nix
    Replies: 8
    Last Post: 9th October 2007, 08:44 AM
  3. Domain Express
    By Andi in forum Jokes/Interweb Things
    Replies: 2
    Last Post: 4th May 2007, 08:40 AM
  4. Anyone recommend Smoothwall Express?
    By OverWorked in forum *nix
    Replies: 15
    Last Post: 26th January 2006, 12:37 PM
  5. Outlook Express mailstore.
    By Dos_Box in forum Windows
    Replies: 3
    Last Post: 1st July 2005, 02:58 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
  •