Not sure how much I missed in the thread but: Did you specifically limit sql server to use 1 cpu? Are you using a version of SQL server that only supports 1 cpu such as Sql 2005 express. It's possible that the tasks you're doing are not able to run multithreaded (i.e. only 1 thread can read 8 gigs of stuff into memory, insert into table, etc..). If you split up the files and run separate transactions (If possible), you might be able to speed up the task and achieve greater cpu utilization.
Russ > -----Original Message----- > From: Snake [mailto:[EMAIL PROTECTED] > Sent: Monday, September 04, 2006 5:34 AM > To: CF-Talk > Subject: RE: SQL Server CPU Utilization maxes at 25% > > Unless you have specifically told SQL server to use a specific CPU, it > should be using all of them anyway. > > Russ > > -----Original Message----- > From: Denny Valliant [mailto:[EMAIL PROTECTED] > Sent: 04 September 2006 04:13 > To: CF-Talk > 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:251975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
