J
James Palmer
Guest
Just a question out of interest more than anything as we are committed to sorting this out whether or not it makes a difference. Somehow one of our clients has managed to get the BI on their DB set to 4 fixed 2GB extents and a variable extent. I'd be surprised if the BI ever fills the first extent on a bad day. The issue is that whenever the backups kick in they are experiencing a freeze, in keeping with the backup backing up the BI. This is even happening just after a truncate. The question is, is this freeze going to be longer in their situation of around 8GB of physical BI compared to if they just had a variable extent of a few MB, shortly after a truncate? Hope I've explained that well enough. 10.2B08 on Windows.
Continue reading...
Continue reading...