Database Benchmarking and Stress Testing by Bert Scalzo

Author:Bert Scalzo
Language: eng
Format: epub
ISBN: 9781484240083
Publisher: Apress

Keep References Handy

In Chapter 2, I stressed how important it is to read the database benchmarking spec (if one exists) before trying to run some software that implements that benchmark. The reason was to understand what it’s all about and to be able to answer any questions the software might ask, which might expect your answers to be within spec guidelines. For example, the TPC-C says 10 concurrent users per warehouse; therefore if you want to test with 10,000 users you need to set a scale factor of 1,000. However, keeping the spec handy might be critical when you encounter those speed bumps that I mentioned always occur. Sometimes a potential database tuning technique you want to try may or may not be allowed to overcome those issues. The three most common questions include:Is adding additional indexes or modifying the current indexes permitted (e.g., switch column order)?

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.