delete generating >1Gb logbackup / hour
-
We've ativated this delete procedure.
It basicaly selects buckets to be deleted , then deletes all the contents and finaly deletes the bucket.
Although my net KB-reserved decreases by +-650Mb, my incremental logbackups grow with 1Gb up to 1,3Gb per hour ! (hourly scheduled logbackup).
Before we activated this proc, the logbackup grew on average 10Mb/hour
The databases recovery regime is BULK_Logged.
IMO there should only be one log-entry per deleted row but why this logbackup-load of > 1Gb/hour ??
This is on SQL2000 sp3a
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I'm gonna go out on a limb and presume that logging takes more space than the actual data... but 2X, that's seems a lot.
Maybe a lot of indexes need to be updated by this delete ?!.
-
update : the dev-team did put on the wrong track .... _not_ mentioning some tiny little bits ...
I went back to them and talked a bit regarding their process.
Now they told me they select their master-data to be deleted into a materialized persistant table in this database.
So I think this explains the log-load ! The UpperCreature knows what else they are doing.
I'm going to dig in this process and hope I can bring up some enhancements .... starting with moving that data to tempdb
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Ya like select the data you want to keep then drop that table... but I'm sure you knew about that one
.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply