March 2008
Intermediate to advanced
326 pages
10h 22m
English
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 ...
Read now
Unlock full access