 |
|
SQL Server Tips by Robin Schumacher
|
Physical Design Revisions
As has been repeated throughout this book, the biggest area for
performance gains almost always comes from things done at the
physical design level. Of course, it is always best if a DBA creates
a proper physical design in the first place, so one should strive to
create a physical design that excels from the start.
Even the best designs need tweaking from time to time, so the DBA
can expect to revise certain areas of the design to keep performance
high. These areas include the following:
Some of these areas may be difficult to
accomplish if dealing with packaged applications, but there are
areas in which the DBA still has some degree of control. Before each
of these points is explained in detail, it is advantageous to know
what tools Microsoft provides to help with these tasks.
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets
ISBN:
0-9761573-6-5
Robin Schumacher
http://www.rampant-books.com/book_2005_2_sql_server_dba.htm |
