+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, SIMS database engine in Technical; Has anyone upgraded from MS SQL 2005 Express and if so did it make any difference to the speed ta ...
  1. #1

    Join Date
    Jan 2008
    Posts
    48
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    SIMS database engine

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

    ta

    mal

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    It should not make a difference. If you have speed issues then it is being caused by something else - perhaps anti-virus software.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    Quote Originally Posted by PhilNeal View Post
    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?

  4. #4
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    Quote Originally Posted by localzuk View Post
    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.

  5. Thanks to meastaugh1 from:

    localzuk (27th January 2008)

  6. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    Quote Originally Posted by meastaugh1 View Post
    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?

  7. #6
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    Yeah I'm sure it will when you start to reach the limits. Just a different method to impede performance.

  8. #7

    Join Date
    Oct 2005
    Location
    Lancashire
    Posts
    110
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by PhilNeal View Post
    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

  9. #8

    Join Date
    Jan 2008
    Posts
    48
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    SQL express

    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

  10. #9
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24
    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?

  11. #10
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24
    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?

  12. #11
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34
    Quote Originally Posted by Jobos View Post
    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

  13. #12
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,134
    Thank Post
    178
    Thanked 49 Times in 42 Posts
    Rep Power
    24
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Can't attach new blank SIMS database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 4th July 2007, 01:49 PM
  2. Accessing SIMS.Net database through ASP?
    By gavcradd in forum MIS Systems
    Replies: 9
    Last Post: 12th June 2007, 12:20 AM
  3. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 9th January 2007, 11:27 PM
  4. ASP connect to SIMS database
    By ryan_powell in forum MIS Systems
    Replies: 1
    Last Post: 26th October 2006, 06:31 PM
  5. SIMS Database & Log File
    By indiegirl in forum MIS Systems
    Replies: 14
    Last Post: 17th March 2006, 03:00 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
  •