« The Pitfalls of Log Shipping on SQL Server | Main | Why Benchmark SQL Server Hardware »
Sunday
29Mar2009

What is Benchmarking in Databases

DateSunday, March 29, 2009 at 11:37PM
  • The measurement of a systems ability to complete transactions normally in Transaction per Second
  • Different standards exists for both OLTP OLAP type databases
  • Allows you to understand the hardware cost per transaction
  • Definable and consitent set of tests

Resources for Performing Benchmarking

TPC is a non-profit group that publish benchmark tests and results  

Benchmark Factory they have a freeware version which is a great start

Microsoft has a great TechNet article on Predeployment I/O Best Practices which is great for understanding the performance capabilities of your Disk I/O

AuthorSQLBloke | CommentPost a Comment | Print ArticlePrint Article | |

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>