+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, SIMS/SQL CPU core utilisation in Technical; I've recently P2V converted our SIMS server to an ESXi(4) host. I'm trying to ensure is all well for the ...
  1. #1
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32

    SIMS/SQL CPU core utilisation

    I've recently P2V converted our SIMS server to an ESXi(4) host. I'm trying to ensure is all well for the forthcoming academic year. I noticed while running a query from within SIMS the maximum server CPU utilisation seems to be around 25%. If I run two queries in parallel (ie one from SIMS.net and one from FMS) it maxes out at around 50%. The source machine was P4 with HT enabled, the virtual machine has four processor cores. All processor settings in SQL are set to automatic affinity.

    From what I've read, the only way to limit processor utilisation in 2005 is from within the query itself. Are SIMS queries limited to a certain number of processors per query? Does the above behaviour sound normal? Thanks

    Server 2003 SP2, SQL 2005 SP2 Std.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,410
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Think your limited to 1 thread\core\cpu. Log a call with Capita, they'll be able to give you more info. Assuming you've got 32bit and you've set AWE.

SHARE:
+ Post New Thread

Similar Threads

  1. Intel demos Nehalem-EX octal-core CPU
    By DAckroyd in forum IT News
    Replies: 0
    Last Post: 27th May 2009, 05:12 PM
  2. sims.net SQL Server CPU Spike
    By itgeek in forum MIS Systems
    Replies: 6
    Last Post: 26th February 2009, 12:28 PM
  3. Replies: 10
    Last Post: 4th September 2008, 05:50 PM
  4. Ghosting sims @ sql
    By pooley in forum MIS Systems
    Replies: 0
    Last Post: 13th March 2008, 09:40 AM
  5. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 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
  •