國立虎尾科技大學 |

Database Benchmarking and Stress Testing = An Evidence-Based Approach to Decisions on Architecture and Technology /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Database Benchmarking and Stress Testing/ by Bert Scalzo.
Reminder of title:	An Evidence-Based Approach to Decisions on Architecture and Technology /
Author:	Scalzo, Bert.
Description:	XVIII, 240 p. 111 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-4008-3
ISBN:	9781484240083

Database Benchmarking and Stress Testing = An Evidence-Based Approach to Decisions on Architecture and Technology /
Scalzo, Bert.

Database Benchmarking and Stress TestingAn Evidence-Based Approach to Decisions on Architecture and Technology /[electronic resource] :by Bert Scalzo. - 1st ed. 2018. - XVIII, 240 p. 111 illus.online resource.

1. Benchmarking Basics -- 2. Industry Standard Benchmarks -- 3. Benchmarking Tools -- 4. Benchmarking Preparation -- 5. Benchmarking Mistakes -- 6. Benchmarking Hardware Options -- 7. Benchmarking Software Options -- 8. Benchmarking for Consolidation -- 9. Benchmarking for Virtualization -- 10. Benchmarking for Public Cloud -- 11. Workload Capture and Replay -- 12. Database Stress Testing.

Provide evidence-based answers that can be measured and relied upon by your business. Database administrators will be able to make sound architectural decisions in a fast-changing landscape of virtualized servers and container-based solutions based on the empirical method presented in this book for answering “what if” questions about database performance. Today’s database administrators face numerous questions such as: What if we consolidate databases using multitenant features? What if we virtualize database servers as Docker containers? What if we deploy the latest in NVMe flash disks to speed up IO access? Do features such as compression, partitioning, and in-memory OLTP earn back their price? What if we move our databases to the cloud? As an administrator, do you know the answers or even how to test the assumptions? Database Benchmarking and Stress Testing introduces you to database benchmarking using industry-standard test suites such as the TCP series of benchmarks, which are the same benchmarks that vendors rely upon. You’ll learn to run these industry-standard benchmarks and collect results to use in answering questions about the performance impact of architectural changes, technology changes, and even down to the brand of database software. You’ll learn to measure performance and predict the specific impact of changes to your environment. You’ll know the limitations of the benchmarks and the crucial difference between benchmarking and workload capture/reply. This book teaches you how to create empirical evidence in support of business and technology decisions. It’s about not guessing when you should be measuring. Empirical testing is scientific testing that delivers measurable results. Begin with a hypothesis about the impact of a possible architecture or technology change. Then run the appropriate benchmarks to gather data and predict whether the change you’re exploring will be beneficial, and by what order of magnitude. Stop guessing. Start measuring. Let Database Benchmarking and Stress Testing show the way. What You'll Learn: Understand the industry-standard database benchmarks, and when each is best used Prepare for a database benchmarking effort so reliable results can be achieved Perform database benchmarking for consolidation, virtualization, and cloud projects Recognize and avoid common mistakes in benchmarking database performance Measure and interpret results in a rational, concise manner for reliable comparisons Choose and provide advice on benchmarking tools based on their pros and cons.

ISBN: 9781484240083

Standard No.: 10.1007/978-1-4842-4008-3doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Database Benchmarking and Stress Testing = An Evidence-Based Approach to Decisions on Architecture and Technology /
LDR:04384nam a22004095i 4500 001 988864
003 DE-He213
005 20200702104145.0
007 cr nn 008mamaa
008 201225s2018 xxu| s |||| 0|eng d
020 $a 9781484240083 $9 978-1-4842-4008-3
024 7 $a 10.1007/978-1-4842-4008-3 $2 doi
035 $a 978-1-4842-4008-3
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Scalzo, Bert. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1210713
245 1 0 $a Database Benchmarking and Stress Testing $h [electronic resource] : $b An Evidence-Based Approach to Decisions on Architecture and Technology / $c by Bert Scalzo.
250 $a 1st ed. 2018.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2018.
300 $a XVIII, 240 p. 111 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a 1. Benchmarking Basics -- 2. Industry Standard Benchmarks -- 3. Benchmarking Tools -- 4. Benchmarking Preparation -- 5. Benchmarking Mistakes -- 6. Benchmarking Hardware Options -- 7. Benchmarking Software Options -- 8. Benchmarking for Consolidation -- 9. Benchmarking for Virtualization -- 10. Benchmarking for Public Cloud -- 11. Workload Capture and Replay -- 12. Database Stress Testing.
520 $a Provide evidence-based answers that can be measured and relied upon by your business. Database administrators will be able to make sound architectural decisions in a fast-changing landscape of virtualized servers and container-based solutions based on the empirical method presented in this book for answering “what if” questions about database performance. Today’s database administrators face numerous questions such as: What if we consolidate databases using multitenant features? What if we virtualize database servers as Docker containers? What if we deploy the latest in NVMe flash disks to speed up IO access? Do features such as compression, partitioning, and in-memory OLTP earn back their price? What if we move our databases to the cloud? As an administrator, do you know the answers or even how to test the assumptions? Database Benchmarking and Stress Testing introduces you to database benchmarking using industry-standard test suites such as the TCP series of benchmarks, which are the same benchmarks that vendors rely upon. You’ll learn to run these industry-standard benchmarks and collect results to use in answering questions about the performance impact of architectural changes, technology changes, and even down to the brand of database software. You’ll learn to measure performance and predict the specific impact of changes to your environment. You’ll know the limitations of the benchmarks and the crucial difference between benchmarking and workload capture/reply. This book teaches you how to create empirical evidence in support of business and technology decisions. It’s about not guessing when you should be measuring. Empirical testing is scientific testing that delivers measurable results. Begin with a hypothesis about the impact of a possible architecture or technology change. Then run the appropriate benchmarks to gather data and predict whether the change you’re exploring will be beneficial, and by what order of magnitude. Stop guessing. Start measuring. Let Database Benchmarking and Stress Testing show the way. What You'll Learn: Understand the industry-standard database benchmarks, and when each is best used Prepare for a database benchmarking effort so reliable results can be achieved Perform database benchmarking for consolidation, virtualization, and cloud projects Recognize and avoid common mistakes in benchmarking database performance Measure and interpret results in a rational, concise manner for reliable comparisons Choose and provide advice on benchmarking tools based on their pros and cons.
650 0 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484240076
776 0 8 $i Printed edition: $z 9781484240090
776 0 8 $i Printed edition: $z 9781484247815
856 4 0 $u https://doi.org/10.1007/978-1-4842-4008-3
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)