[sims] SQL version

[jonnybradley]

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

[Bananas]

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

[vikpaw]

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.

[jonnybradley]

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

[Banjo]

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

[Bananas]

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