Kbase 20123: How to Use the BI File block size to Test OS Block Size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/11/2008 |
|
Status: Verified
GOAL:
How a database's before-image (BI) file can be used to test the block size of the operating system?
GOAL:
How do I know the file size of my operating system given the bi block size and database performance?
GOAL:
How does bi file block size affect performance?
FIX:
The BI blocksize can be used to determine the default OS block size. If the BI block size is currently 8K, check to see how performance is after changing it to 1K. Change the block size to 1K and once again check performance. If there is no perceivable difference, the file system block size is very likely 1K. If there is a difference in performance, the file system block size is likely 8K.
Of course, this is just a rule of thumb, the performance and bi blocksize could be related to other factors.