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 ...
27th July 2009, 10:39 AM #1
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.
IDG Tech News
27th July 2009, 10:56 AM #2
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.
By DAckroyd in forum IT News
Last Post: 27th May 2009, 05:12 PM
By itgeek in forum MIS Systems
Last Post: 26th February 2009, 12:28 PM
By tosca925 in forum Windows
Last Post: 4th September 2008, 05:50 PM
By pooley in forum MIS Systems
Last Post: 13th March 2008, 09:40 AM
By steve in forum MIS Systems
Last Post: 20th August 2007, 01:35 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)