>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only