Database Benchmarking: Practical Methods for Oracle & SQL Server
Rampant TechPress, 2007 - Computers - 182 pages
In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Databases that Benefit from Predictive Analysis
Both Insert and Select Varying
Materialized View with No Partitions
Stress Testing Specific Workloads
Stressing Specific Database Platforms
Concentrate on What and not How
Running Benchmark Jobs
Dont Rush to Conclusions
Combined Results Summary
20 SELECT user 78 users activity ANSI SQL standard application architecture AS3AP base tables Benchmark Factory benchmark results benchmark tests bottlenecks cache chapter concurrent users configuration consolidated correlation create index database benchmarking database performance database professional database server database systems DEGREE 8 INSTANCES environment example execute gigabytes graph hyperthreading increase industry standard benchmarks Information INSERT processing issues iterations Linux materialized view megabytes memory Microsoft SQL Server monitored MV_AUTHOR_SALES node ODBC OLTP operating system optimal Oracle database Oracle RAC PARALLEL DEGREE parameters PARTITION performance metrics Phase physical reads predictive production Profile queries query optimizer RAID5 read-only Scalable Hardware scale factor scripts SELECT processing shown in Figure shows specific Spotlight on SQL SQL Server 2005 stress test Test Run TPC-C benchmark TPC-D TPC-H transaction processing transactions per second user increments user load utilized VALUES LESS virtual server vmstat Windows workload