Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

Chapter 6 Improving Sybase database performance with
Veritas Cached Quick I/O ............................................. 89
Tasks for setting up Cached Quick I/O .............................................. 89
Enabling Cached Quick I/O on a file system ....................................... 90
Enabling and disabling the qio_cache_enable flag ........................ 90
Making Cached Quick I/O settings persistent across reboots and
mounts .......................................................................... 91
Using vxtunefs to obtain tuning information ............................... 92
Determining candidates for Cached Quick I/O ................................... 94
Collecting I/O statistics ........................................................... 94
About I/O statistics ................................................................ 95
Effects of read-aheads on I/O statistics ....................................... 96
Other tools for analysis ........................................................... 96
Enabling and disabling Cached Quick I/O for individual files ................ 97
Setting cache advisories for individual files ................................ 97
Making individual file settings for Cached Quick I/O
persistent ....................................................................... 98
Determining individual file settings for Cached Quick I/O using
qioadmin ........................................................................ 99
Chapter 7 Improving database performance with Veritas
Concurrent I/O ............................................................. 101
About Concurrent I/O .................................................................. 101
How Concurrent I/O works ..................................................... 101
Enabling and disabling Concurrent I/O ........................................... 102
Enabling Concurrent I/O for DB2 ............................................. 102
Disabling Concurrent I/O for DB2 ............................................ 104
Enabling Concurrent I/O for Sybase ......................................... 105
Disabling Concurrent I/O for Sybase ........................................ 105
Section 3 Storage Foundation Thin Storage
optimization ............................................................ 107
Chapter 8 About SF Thin Storage optimization solutions ............ 109
About SF solutions for thin optimization ........................................ 109
About Thin Storage ..................................................................... 110
About Thin Provisioning .............................................................. 110
About SF Thin Reclamation feature ............................................... 110
About SmartMove ...................................................................... 110
Using SmartMove with Thin Provisioning ................................. 111
9Contents