Database Benchmarking: Practical Methods for Oracle & SQL Server

Dr. Bert Scalzo, Kevin Kline, Claudia Fernandez, Mike Ault, Donald Burleson

  • 出版商: Rampant Tech Press
  • 出版日期: 2007-04-01
  • 售價: $1,400
  • 貴賓價: 9.5$1,330
  • 語言: 英文
  • 頁數: 200
  • 裝訂: Paperback
  • ISBN: 0977671534
  • ISBN-13: 9780977671533
  • 相關分類: MSSQLOracleSQL資料庫
  • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

Description

Every information system must know their limits.  As systems grow, resources are stressed and one of the major causes of unplanned database outages is a failure to anticipate the effects of growth.

Benchmarking is a critical job function and every database professional must understand the principles of capacity planning and database bottleneck analysis.  By using a benchmark method you can spot areas of pending problems before they cripple your database.

This landmark book explores all aspects of database benchmarking and shows you a real-world approach that ensures that you are prepared for whatever the future brings to your mission-critical database.

 

Table of Contents

Using the Online Code Depot
Supplemental Materials
Conventions Used in this Book
Acknowledgements
Preface
Database Predictive Analysis
Database Benchmark Validity
The Problems of Adaptive Threshold Forecasting
Predictive Modeling in the Real-world
Databases that Benefit from Predictive Analysis
The Transaction Processing Performance Council
Benchmarking Bi-modal Databases
Capacity Planning and Performance Testing
Forecasting the Future
Database Benchmarking Myths
Learning from Database Benchmarks
Conclusion
Database Benchmarking
Industry Standard Benchmarks
Basic Benchmark Components
Specifications
Details
Design Goals
Data Points
Test Plan
Control Logic
Repeatability
Accurate Statistics
Database Benchmarks with Benchmark Factory
TPC-C
TPC-H
TPC-E
ASAP and Scalable Hardware
Benchmarking with a Custom Workload
Conclusion
Introduction
Trend Identification with Benchmark Tools
Testing a Suggested Architecture
System Information
Database Objects
Details of Materialized View
Transaction Details
Insert Transaction
Select Transaction
Phase : Both Insert and Select Varying
Phase : SELECT Transaction Level Constant
Concurrent SELECTS
Concurrent SELECTS
Concurrent SELECTS
Phase : Materialized View with No Partitions


  Combined Results
Combined Results Summary
Recommendations
Planning Future Hardware & Software Needs
Architecture
Executive Summary
Limitations and Caveats
Phase : Issues Query Testing
Randomization of the Issues Queries
Transaction Times for Issues Tests
Average Transaction Times
Database Activity
Operating System Activity
Phase Conclusion
Maintaining Service Level Agreements (SLA’s)
Determining SLA Test Queries
Ok here is the SLA and Queries What Now?
Issues with Generating Your Own Scripts
The Easy Way
Supporting Server & Storage Consolidations
Database Implosion Therapy
Hardware Issues in Stress Testing
Configuring the Server Environment
Stress Testing Specific Workloads
Stressing Read-Only Databases (Read-only Implosion)
Stressing OLTP Databases (DML Implosion)
Stressing Mixed Databases (General Implosion)
Stressing Specialized Environments
Stressing Distributed Systems
Stressing Consolidated Systems
Stressing Virtualized Systems
Stressing Specific Database Platforms
Not all SQL Implementations up to Spec
Not all Query Optimizers Created Equal
Conclusion
Isolate the Benchmark Environment
Prepare the Server Operating System
Windows
Linux
Prepare the Database Configuration
SQL Server
Oracle
Concentrate on What and not How
Installing Benchmark Factory
Conclusion
Selecting among Benchmarks
Creating Benchmark Jobs
Running Benchmark Jobs
Monitoring Benchmark Runs
Special Oracle RAC Considerations
Conclusion
Don’t Rush to Conclusions
An Example on Oracle
An Example on Microsoft SQL Server
Finding the “Sweet Spot”
When Conclusions are not Self-Evident
Correlating Results
Real-time versus “Run” Reports
Extrapolation & Interpolation
Documenting the Final Analysis

 

商品描述(中文翻譯)

描述

每個資訊系統都必須了解自己的限制。隨著系統的成長,資源會受到壓力,而未計劃的資料庫故障的主要原因之一就是未能預見成長的影響。

基準測試是一項關鍵的工作職能,每個資料庫專業人員都必須了解容量規劃和資料庫瓶頸分析的原則。通過使用基準方法,您可以在問題發生之前發現潛在問題的領域,以免使您的資料庫陷入瘫痪。

這本里程碑式的書籍探討了資料庫基準測試的各個方面,並向您展示了一種現實世界的方法,確保您對任何可能影響您的關鍵任務資料庫的未來做好準備。

目錄

使用線上代碼倉庫
補充材料
本書使用的約定
致謝
前言
資料庫預測分析
資料庫基準測試的有效性
自適應閾值預測的問題
現實世界中的預測建模
從預測分析中受益的資料庫
交易處理性能委員會
基準測試雙模式資料庫
容量規劃和性能測試
預測未來
資料庫基準測試的迷思
從資料庫基準測試中學習
結論
資料庫基準測試
行業標準基準測試
基本基準測試組件
規格
細節
設計目標
數據點
測試計劃
控制邏輯
可重複性
準確的統計數據
使用基準工廠進行資料庫基準測試
TPC-C
TPC-H
TPC-E
ASAP和可擴展硬件
使用自定義工作負載進行基準測試
結論
介紹
使用基準工具進行趨勢識別
測試建議的架構
系統信息
資料庫對象
物化視圖的細節
交易細節
插入交易
選擇交易
階段:插入和選擇變化
階段:選擇交易級別恆定
並發選擇
並發選擇
並發選擇
階段:無分區的物化視圖
合併結果
合併結果摘要
建議
規劃未來的硬件和軟件需求
架構
執行摘要
限制和注意事項
階段:問題查詢測試
問題查詢的隨機化
問題測試的交易時間
平均交易時間
資料庫活動
操作系統活動
階段結論
維護服務水平協議(SLA)
確定SLA測試查詢
好了,這是SLA和查詢,現在該怎麼辦?
生成自己的腳本的問題
簡單的方法
支援服務器和存儲合併
資料庫內部治療
壓力測試中的硬件問題
Conf```