|
Posted by Enorme Vigenti on 10/16/07 07:33
Hi all, I have a problem with sqlserver 2000 and large data management.
I have a database with a large tables.
Every table has a continuative input data flow
every morning a job delete old records from the tables (delete one most
old day)
but sometimes I belive that this operation is blocking for the table and
the continuative data flow on that table fails for timeout.
Infact the delete operation is most espesive in time resource. (4-5 hour
for every table)
I must say that the table has an index on datetime field.
I can't use trucate table because I can't delete all records.
In delete table can't use the option "with no lock"
perhaps I must to recalc datatime index on a table before delete? any
other idea?
tnx in advance
Navigation:
[Reply to this message]
|