||SQL Server Tips by Robin Schumacher
The Simplified Performance
When approaching tuning in SQL Server, the DBA will work through the
following three areas:
Thatís it. There can be a lot of complexity
and effort involved in working through these steps, but broadly
speaking, these are the categories the DBA will be engaged in.
The first thing to understand is these three areas are presented in
reverse order of their usual performance impact. This means making
configuration changes will buy the least amount of performance
optimization. Making SQL optimization changes will buy more
performance optimization, and making physical design revisions has
the largest potential for performance increase.
These steps are presented according to ease of application. It is
not usually a problem to make SQL Server parameterization or server
configuration tweaks. SQL optimization is less dangerous and less
complex than making physical design revisions.
The remaining sections of this chapter will work through each step
and correlate diagnostics presented in earlier chapters with
recommendations for performance improvement. The meaning of the
various diagnostics along with how to obtain them will not be
covered again. Therefore, if a particular statistic is needed, the
index of this book should be utilized to locate the correct chapter
in which the particular metric is covered in detail.
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets