[Prior Post in Series]
In this 5 part Benchmarking Series we have discussed:
We're now going to discuss the Benchmarking Process itself.
"How do you measure up?"
The start of any benchmark needs to be a clear understanding by everyone involved as to what the end goal is. This ties very closely to what was discussed in "The Need for Benchmarking" post in this series. Some examples of possible end goals:
ASSESSMENT / REVIEW
This is where you take all the elements of your benchmark (as discussed in "The Elements of a Benchmark" post in this series) and execute your tests to understand how your environment will perform in relation to the question(s) being asked in your "end goal". Outputs of this exercise can be (as described in "The Applicability/Usage of a Benchmark" post in this series):
Now that we understand our "end goal" and we've done our "assessment/review" if we haven't achieved success we need to develop and implement an action plan to address the items found in the assessment. Items that should be discussed in this action plan can be:
At this point (once the Action Plan has been implemented) you will go back to the Assessment/Review phase and gather new benchmark results. This cycle will continue until you are happy with your results and have been able to answer the question(s) from your End Goal.
The final part of the Benchmarking Process (depending on what your End Goal was) might be to create a whitepaper to summarize and report the findings. Information that might be included:
"You don't know where you are going till you know where you've been"
Benchmarks should play an important role in your enviroment. Whether you are using them for release management, determining scalability, or troubleshooting it's important to have hard facts about how your environment performs under normal conditions. Having the right hardware, software, and repeatable tests in place will help you identify what bottlenecks you might have (and under what conditions). This information allows you to make changes and have a good understanding as to how those changes will affect the overall performance of your environment which helps ensure the overall stability of the system.
Follow Tier1OnSQL on Twitter