>>>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 :)
on SQL Server the hardware problems in order is :
1. RAM size
2. Storage write performance
3. CPU performance
Previous
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