DB Benchmarking

Comments: 3 Comments
Published on: March 14, 2011

As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance.  When benchmarking, it is preferable to get a baseline and then run the same benchmark tests on a periodic basis and compare those results to the baseline.

Recently I was reminded of a couple of tools that should be in every DB Professionals vocabulary and tool set.  Each one is used for a different purpose.  Those tools are:

  1. CPU-Z
  2. TPC-E

CPU-Z is a freeware app that helps you gather information about motherboard, CPU, and memory.  It helps you to determine processor usage and if you are running your hardware at an optimal level.

TPC-E simulates the OLTP workload.  It is designed to be representative of OLTP systems and is scalable.

Both of these tools can be of great use to the database professional.  Check them out and see what you can learn by using them.

3 Comments - Leave a comment
  1. Joe Webb says:

    Thanks SQLRnnr. This is an important topic that is often overlooked.

    Kevin Kline has a pretty good book on the subject. It’s largely focused on Quest’s Benchmark Factory product, but you can glean quite a bit of good general purpose info from it too. http://amzn.to/dRdXTI

    • Jason Brimhall says:

      Excellent feedback. Thanks for the info on the book. I hope that these resources will be of good use (and be used) to others.

  2. [...] @sqlrnnr posts DB Benchmarking Posted on March 15, 2011 by sqlmashup http://jasonbrimhall.info/2011/03/14/db-benchmarking/ [...]

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">






Calendar
March 2011
M T W T F S S
« Feb   Apr »
 123456
78910111213
14151617181920
21222324252627
28293031  
Content
SQLHelp

SQLHelp


Welcome , today is Tuesday, September 23, 2014