June 6, 2004 at 7:59 am
Hello,
Iam sure, the Gurus may call it foolishness. Still an issue is an issue.
We have SQL Server 2000, having a database whose existing size is 25GB.Its been used for a web-based OLTP application.
Along with various other tables we have a set of 8 transactional tables, which have all the transactions, each day the total number of records being updated/inserted in these 8 tables varies from 8 to 10 Millions.
As a weekly maintenance we have a Purge program- A scheduled SQL Task invoking a SP which copies the data from the existing 8 tables to a replica of the same 8 tables within the same database depending upon certain date criteria.
The issue is, during the run of the weekly purge program, the set of 8 live tables,becomes inaccessible, untill the run is complete which takes around 2 hrs. So for the 2 hrs of the run, any query hitting the set of 8 tables, goes in a never ending wait, till it gets timed out. Thus making the application dead for complete 2 hrs.
Any valuable inputs from the gurus will be highly appreciated.
Thanks
Pervez Khan
June 6, 2004 at 11:49 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply