Database Reference
In-Depth Information
Implementing performance baseline
practices
Let's see what practices we need to measure a performance baseline and how best we
can implement them. These measurements must be taken during on-peak and off-peak
hours on the data platform from a typical resource-intensive operation. All the subsequent
measurements are compared with relevant baselines, and to determine the course of action
we need to establish performance thresholds. These thresholds will help the DBAs to trigger
fine tuning methods before a performance downtrend approaches. In this recipe, we will
implement the performance baseline practices on the data platform that will help us to keep
up the scalability and availability.
Getting ready
The essential tools to implement performance baseline practices are:
F Using the SQL Server 2008 R2 instance with a database that will perform unit testing
for a baseline.
F Dynamic Management View (DMVs): These are pre-installed within the core
database engine.
F Data collector: It is an automated way to collect data and obtain summary reports
about disk usage, query statistics, and server activity.
F Windows Performance Monitor—PERFMON (SYSMON): This tool is used to collect a
range of counters.
F SQL Server tracing tool—SQL PROFILER.
F Preparing the SQL Server instance for peak workloads. Use a load testing tool
such as Visual Studio Team System (VSTS) 2008 Database Edition or 2010
Development Edition.
Download VSTS 2008 from http://www.microsoft.com/downloads/
en/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-
8f55759846ed&displaylang=en .
To use the generated code (own scripts) in a load test scenario, we need to
have the VSTS2008 Test Edition and VSTS2008 Team Suite installed on the
same machine where the SQL Server instance exists.
Refer to http://www.microsoft.com/downloads/en/details.
aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displ
aylang=en#Instructions for instructions on VSTS2008 tool installation.
 
Search WWH ::




Custom Search