+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SQL version in Technical; Hello, Looking for some advise on SQL versions for running the Sims database. We currently run the Sims database in ...
  1. #1

    Join Date
    Jun 2014
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SQL version

    Hello,

    Looking for some advise on SQL versions for running the Sims database.

    We currently run the Sims database in MS SQL 2008 express. One lesson monitor query quite often causes Sims to crash on the workstaion displaying a sims error dialog message of

    The database query timed out : SIMS.Entities.DatabaseExceptionTimeout

    When I look at SQL server Management Studio the query puts the CPU up to 25% (express can only use 1 of the 4 cores the server has right?) and stays there till it completes or times out.

    So my question is should buying SQL Standard allow Sims database to use more than 1 core? Should I have to do anything to the Sims database to make it use the extra cores (licencing from Capita) or will this happen automatically?

    Any input appreciated

    Jon

  2. #2

    Join Date
    Jan 2012
    Posts
    679
    Thank Post
    264
    Thanked 98 Times in 81 Posts
    Rep Power
    27
    I THINK that just changing SQL versions will sort the single core issue out and that you shouldn't need to do anything else, but having said that i'd check with support as there maybe a procedure to follow

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,784
    Thank Post
    715
    Thanked 1,439 Times in 1,192 Posts
    Rep Power
    359
    I think if you upgrade it should automatically pick things up.
    It's a good time to install 2012 and then migrate and it will definitely use all the resources.

  4. #4

    Join Date
    Jun 2014
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks both!

    Yeah would go with 2014 licence and then down grade it back to 2012. Sims prob wont support 2014 till spring update so will have to migrate twice

    Any more input appreciated

  5. #5

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17
    SQL Express isn't recommended for a secondary phases regardless of the edition. You might have a shock when you come to licence the full version

  6. #6

    Join Date
    Jan 2012
    Posts
    679
    Thank Post
    264
    Thanked 98 Times in 81 Posts
    Rep Power
    27
    Our previous nm said that the ms licensing (forget the name the fte one) allows you to use everything.

    Reckon the school could be in for a shock lol

SHARE:
+ Post New Thread

Similar Threads

  1. [Windows Software] SQL version - with or without cals?
    By reggiep in forum Licensing Questions
    Replies: 7
    Last Post: 4th October 2013, 03:11 PM
  2. SCCM - Which OS & SQL version?
    By sidewinder in forum Enterprise Software
    Replies: 4
    Last Post: 18th September 2013, 05:40 PM
  3. [SIMS] SIMS SQL Version...
    By IKWeb in forum MIS Systems
    Replies: 30
    Last Post: 12th February 2011, 08:25 AM
  4. Difference between SQL versions
    By edutech4schools in forum MIS Systems
    Replies: 11
    Last Post: 28th May 2010, 01:17 PM
  5. Which SQL version?
    By dave.81 in forum MIS Systems
    Replies: 6
    Last Post: 13th August 2008, 12:55 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
  •