It should do this automatically as far as I know. SQL server should use both CPU cores as and when it is required.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Denny Valliant To: CF-Talk Sent: Mon Sep 04 04:12:58 2006 Subject: Re: SQL Server CPU Utilization maxes at 25% Good tip, Jenny. I think it boiled down to looking at a combined graph, instead of a per processor one. Maybe the question is how to spread the load to the other processors now? Eh... On 9/2/06, Jenny Gavin-Wear <[EMAIL PROTECTED]> wrote: > > Hi Rick, > > Could it be a knock on effect of memory resource usage? How does that > look in Perf Monitor? > > I am assuming you are running Win 2003 Server (or similar)? > > Look in C/Panel => System => Advanced => Performance => and check that > Background_services and System_cache are selected. > > Jenny > > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: 01 September 2006 14:10 > To: CF-Talk > Subject: OT: SQL Server CPU Utilization maxes at 25% > > > I have a fairly large bulk insert DTS task in SQL Serve that loads 5 gig > or so of data into our database every morning. It drops the original > tables, bulk inserts the data, then recreates all the indexes. No > logging, etc. > > I'm trying to figure out a way to improve the speed of this process - > but the CPU utilization seems to have some kind of artificial limit of 25% > > See this graph: > http://www.it.dev.duke.edu/temp/sqlcpu.gif > > It seems really odd to me that the CPU usage flatlines at 25%. > > What might be going on here? > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
