SIMS database engine

[interele]

Has anyone upgraded from MS SQL 2005 Express and if so did it make any difference to the speed

ta

mal

[PhilNeal]

It should not make a difference. If you have speed issues then it is being caused by something else - perhaps anti-virus software.

[localzuk]

It should not make a difference. If you have speed issues then it is being caused by something else - perhaps anti-virus software.

Surely this would depend on the number of concurrent connections going to the SIMS server? IIRC MSSQL 2005 Express has a 5 concurrent users at a time limit? So over that number you end up with queuing of requests.

So, say you've got a school with 60 teachers all doing data entry or registering pupils at the same time, you'll end up with a slow down will you not?

[meastaugh1]

Surely this would depend on the number of concurrent connections going to the SIMS server? IIRC MSSQL 2005 Express has a 5 concurrent users at a time limit? So over that number you end up with queuing of requests.

So, say you've got a school with 60 teachers all doing data entry or registering pupils at the same time, you'll end up with a slow down will you not?

Afaik there is no workload governor present in 2005 Express, but it is limited to using 1GB RAM and one processor.

[localzuk]

Afaik there is no workload governor present in 2005 Express, but it is limited to using 1GB RAM and one processor.

Ah, right you are. Still, that could slow it down if there was a lot of disk-swapping going on couldn't it?

[meastaugh1]

Yeah I'm sure it will when you start to reach the limits. Just a different method to impede performance.

[mighty.grey.eagle]

It should not make a difference. If you have speed issues then it is being caused by something else - perhaps anti-virus software.

So, if I turn off the anti-virus software, SIMS will go like an express train? I will try that tomorrow

[interele]

Am I right in thinking ...

MS SQL express = 1 processor - but if the processor has 2 cores it will use both cores

MS SQL express = 1G memory - the old MSDE = 2 Gb

Our old MSDE version of SIMS leaked memory until it was using 1.5G
then it fell over -this usually took about 3-4 weeks

The new version immediately goes to 1.4G and then just goes slow

is this anything like anyone else has seen

ta

Mal

[Jobos]

Our Sims server is running 2 Xeon 2.4 GHz processers and the full version of SQL 2005. During the November upgrade I watched the processer usage and was surprised to see SQL was only using 1 core. I was under the impression that a single processer version of SQL 2005 would use both cores on 1 processer.

Is there a setting for this or a way it can be checked?

[Jobos]

Don't seem to have the management studio installed and the best I can find is the configuration manager. Can the management studio be installed without risk to the Sims?

[sahmeepee]

Our Sims server is running 2 Xeon 2.4 GHz processers and the full version of SQL 2005. During the November upgrade I watched the processer usage and was surprised to see SQL was only using 1 core. I was under the impression that a single processer version of SQL 2005 would use both cores on 1 processer.

It may be set up to be able to use multiple CPUs/cores, but whether it actually does is decided by SQL server itself on a query-by-query basis. SQL server evaluates whether it's faster to split the job up between processors or just run it on one:

Introduction to Parallel Query Execution

[Jobos]

Tried to install the management studio from DVD and are getting an edition change check warning. Moving on from that I click advanced at the components to install list and choose management tools. After clicking next the installer looks like it’s working then I get an error “The feature(s) specified are not valid for this edition of SQL Server”.We are using the SQL 2005 standard version and apart from a service pack nothing has changed.