Uncategorized

DBAs must consider several factors when selecting a database’s block size.  Typically OLTP and mixed workload databases use an 8K block size, while data warehouses are often 16K.   The conventional wisdom is that smaller block sizes are well suited for lots of random I/O (e.g. an OLTP workload) while larger block sizes are appropriate…
Read More…