DB性能优化.ppt

Multi-Temperature Data Management is included only in: - Enterprise Server Edition and - Advanced Enterprise Server Edition Tiered Storage is also know as Hierarchical Storage Management (HSM) Multi-Temperature Data Management is included only in: - Enterprise Server Edition and - Advanced Enterprise Server Edition Tiered Storage is also know as Hierarchical Storage Management (HSM) Multi-Temperature Data Management is included only in: - Enterprise Server Edition and - Advanced Enterprise Server Edition Tiered Storage is also know as Hierarchical Storage Management (HSM) 业务负载的变化给数据库提出了很多挑战，例如铁路售票，秒杀等，这些都需要新的技术手段和方法解决 When you get right down to it, performance is represented as an assessment based on a combination of measurements of how your system responds under a particular workload. A workload is made up of a collection of requests originating from an application made on a system. So naturally the more capacity a system has, the larger the workload can be, but this is not without saying that to get the most out of your system, its available resources, storage, cpu, memory …, needs to be allocated efficiently. 你能想象到十几毫秒能给工作和生活带来哪些变化吗?著名的金融中心华尔街位于美国的东海岸，相比之下，西海岸接收到的股票交易信息会延迟十几毫秒。然而正是这10-20毫秒的交易时间差，足以“操控”金融市场，因此金融市场也被称为“毫秒级战争”。 OLAP中，30分钟出一个报表可能是够快了。 OLTP中，30s处理一个事务太慢了。 时间具有相对性。 随着数据库技术的发展，DBA不需要考虑索引（例如使用存储索引），不需要缓存，不需要物化视图，不需要考虑数据库调优。 例如一体机，IBM pureSystem/Oracle Exadata是调优好的系统 First start with sizing the CPU. CPU capacity is one of the main independent variables in sizing and configuring a system for performance. Because all other hardware configuration typically flows from it, it is not easy to predict how much CPU capacity is required for a given workload. Of course here is where we start to make a distinction in applications types. Business Intelligence systems characterized by fewer concurrent requests that are more resource intensive, especially in terms of data access these systems are usually sized by defining a ratio of processor pow