Indexes

[rsx]

Hello,

I have an MS SQL Server DTS package that truncates a table, drops/creates indexes then inserts new data (about 10 million rows).

There are about 11 indexes on this table which is being used for reading, specifically for reporting purposes.

During execution the database log file increases to over 10 gigs, the cpu use jumps very high, and on occasion it has caused the db to freeze rendering it inoperable.

Any optimizing/tuning techniques out there?

Thanks in advance.

 

[fredericofonseca]

turn transactions off.
Change the insert batch size.

Eventually create the indexes after adding the data.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com