Rick Root wrote: > 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.
> http://www.it.dev.duke.edu/temp/sqlcpu.gif > It seems really odd to me that the CPU usage flatlines at 25%. Might it be a dual-core/hyperthreading, dual CPU/hypertreading or quad-CPU machine? If the system is not I/O bound you can probably improve the performance by running multiple threads and kicking off index builds simultaneously. As soon as you have loaded a table, start building the indexes on it while the loading process continues with the next table. Unfortunately even the online index option of SQL Server 2005 does not mean you can create multiple indexes on the same table simultaneously. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:251752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
