Wiley Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies 978-0-470-17954-3 Benutzerhandbuch
Produktcode
978-0-470-17954-3
Chapter 1: Configuring SQL Server
In This Chapter
⻬
SQL Server configuration tools
⻬
Adjusting server parameters
⻬
Generating configuration scripts
W
ith each new release of SQL Server, Microsoft continues to improve
and simplify the daily tasks of the database administrator. However,
and simplify the daily tasks of the database administrator. However,
it’s still not possible to run the database on autopilot, or replace the DBA
with a robot. Given that reality, this chapter aims to help administrators
make sense of all the server-wide settings and properties that they
encounter each day.
with a robot. Given that reality, this chapter aims to help administrators
make sense of all the server-wide settings and properties that they
encounter each day.
We begin by giving you a brief overview of a collection of SQL Server’s con-
figuration tools and technologies. However, from the day-to-day perspective
of a database administrator, most configuration tuning is controlled via the
SQL Server Management Studio. Consequently, the lion’s share of this chap-
ter is dedicated to understanding how that tool allows you to fine-tune the
dozens of parameters that influence SQL Server’s behavior. Finally, we show
you how to generate scripts so that you can further automate the mainte-
nance and administration of your SQL Server environment.
figuration tools and technologies. However, from the day-to-day perspective
of a database administrator, most configuration tuning is controlled via the
SQL Server Management Studio. Consequently, the lion’s share of this chap-
ter is dedicated to understanding how that tool allows you to fine-tune the
dozens of parameters that influence SQL Server’s behavior. Finally, we show
you how to generate scripts so that you can further automate the mainte-
nance and administration of your SQL Server environment.
SQL Server Configuration Tools
If you’re new to SQL Server, the sheer number of available tactics that
achieve the same goal might confuse you. Part of this is because SQL Server
has been around for many years, and still ships with several legacy tech-
nologies. However, Microsoft has been steadily moving in the direction of
becoming 100-percent graphical, so it’s worthwhile to become familiar with
these tools. Consequently, throughout this book, we devote the majority of
our attention to making the most of the SQL Server Management Studio. We
also point out, however, that character-based approaches to getting the job
done still exist. These same rules apply to many administrative tasks. We
look at each of the major technologies available for performing administra-
tive work.
achieve the same goal might confuse you. Part of this is because SQL Server
has been around for many years, and still ships with several legacy tech-
nologies. However, Microsoft has been steadily moving in the direction of
becoming 100-percent graphical, so it’s worthwhile to become familiar with
these tools. Consequently, throughout this book, we devote the majority of
our attention to making the most of the SQL Server Management Studio. We
also point out, however, that character-based approaches to getting the job
done still exist. These same rules apply to many administrative tasks. We
look at each of the major technologies available for performing administra-
tive work.
If you want to get a holistic view of how these tools work together, see
Book I, Chapter 2.
Book I, Chapter 2.
50_179543-bk08ch01.qxp 8/23/08 12:52 AM Page 603
COPYRIGHTED MATERIAL