>>Hi,
>>I have SQL Server 2008, and want to delete 200 000 records using DELETE FROM [table] WHERE [table].[manufacturer_id]=@tnManufacturerId
>>And this operation is too slow!.. more then 1 minute.
>>I had try to delete it partial within WHILE.. by 1000 records per transaction, but it bring me no performance.
>>I had clustered unique index by ID and also my manufacturer_id I have an index.
>>
>>Is there way to increase performance of DELETE FROM ?
>>
>>Thanks
>>Denis Gavrikov
>
>try to use the slq optimization tool.
>
>check the sql performance counters ( cou,io,lock)
>
>try this:
>exec the delete within a transaction,
>rollback
>redo the delete
>if time changes you have a storage bottleneck
>
>if all is ok, upgrade the hardware.

Hi Fabio,
We have Xeon 2.66 8 CPU 64-bit Windows Environment and 16 GB RAM.. so.. it seems not a hardware problem :)