Database Reference
In-Depth Information
Failure to accurately baseline your source and destination configurations could lead to
the failure of your overall database virtualization project in the worst case, and in the
best case not knowing what the acceptable or expected performance and behavior are.
Not baselining makes troubleshooting significantly more difficult and subjective. It
is very common for customers that do not baseline their existing systems and do not do
gap analysis between physical and virtual to run into unnecessary performance
problems that then take significant time and effort to resolve. Our hope is that by
following the design guidance provided in this topic and baselining your performance,
you will be able to avoid performance problems that would result otherwise, and that
when things change, you'll be able to much more quickly and easily resolve them and
identify the root causes.
When Should You Baseline Performance?
It is good performance management practice to record baseline performance
periodically, and especially before and after any major system changes. Performance
baselines should be measured for both production and non-production systems as part of
standard project and operations processes. A performance baseline should generally be
recorded in the following situations:
As part of the design validation of a new infrastructure, including new vSphere
designs and changes to existing designs or environments
As part of normal business-as-usual activities, before and after any major system
configuration or software changes
When migrating an existing system from one platform to another, either at the
application level or when doing a physical-to-virtual or virtual-to-virtual
migration
As part of introducing a new database to production
During proof of concept or pilot implementation
Regular baselining of your system at key points is one way of managing system
performance to ensure it meets service-level agreements (SLAs).
What System Components to Baseline
This section covers the metrics you should collect at a minimum when baselining your
SQL Server databases. You may choose to collect additional metrics as part of your
baseline as well.
Existing Physical Database Infrastructure
Note
 
 
 
 
Search WWH ::




Custom Search