The database server uses fragmentation of data across coservers to achieve full parallel processing. You can monitor the following aspects of fragmentation:
The database server administrator can monitor data distribution over table fragments. Because the unit of disk storage for a fragment is a tablespace, you monitor tblspaces to monitor fragment and disk use.
If the goal of fragmentation is improved OLTP response time, data access should be distributed evenly over the fragments. To determine an appropriate fragmentation method and scheme, examine the SQL statements that applications use to access the data.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]