You may have hit it on the head. I think the original problem was when Mr. Root was importing 5 gigs of data... I think that was Rick... eh, too lazy to check. =] Another good suggestion though. Sweet.
On 9/4/06, Russ <[EMAIL PROTECTED]> wrote: > > 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:251999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
