M
mfurgal
Guest
Using the BIGROW command to grow 6 x 16 MB cluster makes a 96 MB file. Take the time and do the math to determine the physical write speed. This helps to determine the correct Bi Cluster Size setting. IMO cluster formatting should not take more than 2 seconds, because that would be a noticeable pause for application users. So when Paul breaks out in hives is when the physical write speed is 9.6 MB per second, so the largest BI Cluster size in this case would be 20 MB (I am a fan of powers of 2, so I would make it 16 MB or 24 MB). In rare cases where the update activity requires a larger BI Cluster size than the physical write speed can support, this is when you can pre-grow many BI Clusters, typically 2 times the normal high water mark to make sure there is no unplanned growth or pauses. The downside of this is the online backup time to backup the BI file, unless you are on 11.5 or higher.
Continue reading...
Continue reading...