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:251739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
