+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Sims Multiple Cores in Technical; Hi All Running Sims on dedicated SQL server, SQL 2008, Server 2003 Trying to run some quite complicated marksheets and ...
  1. #1

    Join Date
    Apr 2008
    Location
    Notts
    Posts
    54
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    Sims Multiple Cores

    Hi All

    Running Sims on dedicated SQL server, SQL 2008, Server 2003

    Trying to run some quite complicated marksheets and getting frustrated at speed

    Looked at task manager and Pulsar is only using 1 core on my dual core machine. Tried on a quad core workstation and yet again only using 1 core with cpu usage never going over 25%

    Is this right?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    And what's the server load like?

  3. #3

    Join Date
    Apr 2008
    Location
    Notts
    Posts
    54
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    Its a quad core 2.13 xeon mostly only on 25% with odd peaks up to 50%

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    You can only put 1 physical file onto 1 CPU, so SIMS.mdf will only ever appear on 1 CPU, so you're running on 1x2.12GHz CPU.

    Are you using SQL 2008 express or have you purchased Standard, if you're on express, then your using 1GB ram. The fact your CPU rather high, I would guess you need more ram on the server. Also what RAID are you using? I think the general recommendation is RAID-1 for OS and RAID-5 for data (SQL).

  5. #5
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Not true matt.

    If your using SQL 2008 express then your SQL server can only use 1 core. If your using the full version then your SQL server can take advantage of multiple cores (up to 32 cores I think). I have 4 x 3.16Ghz cores allocated to my SQL server and it flies.

    As far as pulsar on the actual sims workstation goes - it wouldn't surpise me if it was single threaded - it is pretty archaic. I'll do some testing on my quad core sims workstation and see what pulsar uses for me.

    Butuz

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Correct Butuz, you can allocate more CPUs using the standard ed etc, BUT it is physically impossible to get a single file split between two CPUs (without splitting it up - which SQL doesn't do). You will however have SIMS.MDF on CPU1, SIMS.LDF on CPU2, TEMP on CPU3 and so on.

  7. #7

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,778
    Thank Post
    146
    Thanked 564 Times in 508 Posts
    Rep Power
    153
    IIRC, don't run an SQL database on a RAID5 array is the recommendation I've always been given.

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Why's that, SIMS database would be more read then write, which is RAID-5, read\write would be RAID-10 but that's more £££

  9. #9
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Quote Originally Posted by matt40k View Post
    Correct Butuz, you can allocate more CPUs using the standard ed etc, BUT it is physically impossible to get a single file split between two CPUs (without splitting it up - which SQL doesn't do). You will however have SIMS.MDF on CPU1, SIMS.LDF on CPU2, TEMP on CPU3 and so on.
    Not 100% sure what you mean matt. On my SQL server I can get sqlserver.exe to use 90+ % CPU of 4 cores if i run several big SIMS reports on several workstations at the same time.

    I wouldnt imagine SQL 2008 actually loads individual database files to individual cores - it simply would not scale at all if it did that. And it does scale - much further than most Single SIMS server secondary schools????

    Cheers

    Butuz

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    That's how it works, it's not SQL, it's a physical problem. If you have your database split between two CPU, how quickly would it be before it get's corrupt? Not even a second. Only way to get SIMS.MDF onto two or more CPUs would be to split it up into mutliple database files

  11. #11
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Yep - I don't follow either.

    Butuz

  12. #12

    Join Date
    Apr 2008
    Location
    Notts
    Posts
    54
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    All i was trying to do was to run a marksheet that uses nested else ifs to add colours to the grades awarded so these can be displayed in an individual report.

    What is my 'affinity'?

  13. #13
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    I have just run a few tests. Pulsar.exe on SIMS workstations is single threaded. It doesn't appear to be able to make use of multiple CPU's.

    On Dual core workstations Pulsar.exe never uses more than 50% CPU (1 core)
    On Quad core workstations Pulsar.exe never uses more than 25% cpu (1 core)

    Butuz

  14. #14
    Ian_ICTDS's Avatar
    Join Date
    Jun 2009
    Location
    Warwickshire
    Posts
    70
    Thank Post
    11
    Thanked 15 Times in 12 Posts
    Rep Power
    13
    If my memory serves me right you can normally set a multi-core processor to act like a single-core one in the bios somewhere. This would allow single threaded applications to use all four cores as if they where one but to the detriment of everything else.

    Ian.

    EDIT: I'm talking on a client PC here to help pulsar. I wouldn't dream of doing this on a server.
    Last edited by Ian_ICTDS; 22nd November 2010 at 04:56 PM. Reason: Clarification

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 6
    Last Post: 12th September 2011, 10:24 AM
  2. [SIMS] SIMS.net and multiple connect.ini files
    By NortyUK in forum MIS Systems
    Replies: 23
    Last Post: 9th September 2011, 12:05 PM
  3. SIMS Commad Reporter and multiple connections?
    By LosOjos in forum MIS Systems
    Replies: 5
    Last Post: 26th March 2010, 05:34 PM
  4. 75,000 CPU Cores
    By CAM in forum Gaming
    Replies: 1
    Last Post: 18th September 2009, 07:51 PM
  5. SIMS.net Multiple parents / unlinked accounts
    By Sylv3r in forum MIS Systems
    Replies: 3
    Last Post: 21st February 2009, 12:32 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
  •