2.1. Characterizing I/O workload
To determine an application's ideal storage system and disk quantity, it's important to understand the type and volume of I/O the application will generate. This section focuses on the different types of I/O, the metrics used to classify workload, and methods used in measuring and estimating values for the I/O metrics.
In section 2.2, we'll take the information we've learned here and use it to derive the number of disks required to support an application's I/O workload.
2.1.1. OLTP vs. OLAP/DSS
When classifying the nature of I/O, two main terms are used: OLTP and OLAP. An example of an OLTP database is one that stores data for a point-of-sales application, typically consisting of a high percentage of simple, ...
Get SQL Server 2008 Administration in Action 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.
