Database Workloads and Access Patterns
Presenter: Jisha J
Different workloads have different IO access patterns. It is very important to understand the workload characteristics to optimize the performance of the database. The underlying RAID configuration for the IO subsystem should also be configured specific to the application access pattern to get the maximum performance advantage. This session will cover the general access patterns of the different database components for typical OLTP and OLAP workloads. The RAID and disk layouts of the database components like data files, log files, indexes etc would also be discussed with ample details.
About the Speaker
Jisha is a systems engineer working with the Dell Database Solutions group. She holds a Bachelors degree in Computer Science and Engineering and is one of the lead engineers concentrating on designing high performing database solutions. In her role, she is responsible for the configuration and performance characterization of SQL Server with latest Dell hardware technologies. Her areas of expertise include performance characterization of enterprise servers and storages, infrastructure sizing, as well as deployment and performance tuning of database configurations.