>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.