>>>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 :)

16GB is not a big memory today.

How big is the database?

Is the log in simple or full mode ?

post the delete plan.