Chapter 11.3. Data layout overview

Page 204

204 SAN Volume Controller: Best Practices and Performance Guidelines So, what are the traits of a transaction- based application? In the following sections, we explain these traits in more detail. As mentioned earlier, you can expect to see a high number of transactions and a fairly small block size. Different databases use different I/ O sizes for their logs ( see the following examples), these logs vary from vendor to vendor. In all cases, the logs are generally high “ write” workloads. For table spaces, most databases use between a 4 KB and 16 KB blocksize. In some applications, larger chunks ( for example, 64 KB) will be moved to host application cache memory for processing. Understanding how your ...

Get SAN Volume Controller: Best Practices and Performance Guidelines now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.