Wiley Professional SQL Server 2005 Performance Tuning 978-0-470-17639-9 ユーザーズマニュアル
製品コード
978-0-470-17639-9
Wort
c01.tex
V3 - 12/17/2007
7:11pm
Page 3
Performance Tuning
SQL Server 2005 works great right out of the box. For most SQL Server users, performance is never
an issue. They install SQL Server, load up their data, and the system works just great. Over the past
few years, however, there has been an explosion in database size and in the hardware performance
that is available to small and medium-sized businesses. This has allowed many more users to build
larger and larger systems. Many of today’s systems are now larger than yesterday’s enterprise class
systems that required mainframe class hardware. This explosion in size and performance is pushing
more users against the limits of the out-of-the-box performance of SQL Server. This means that more
and more SQL Server users are having to start learning about a side of SQL Server that they never
needed to know about — performance tuning.
an issue. They install SQL Server, load up their data, and the system works just great. Over the past
few years, however, there has been an explosion in database size and in the hardware performance
that is available to small and medium-sized businesses. This has allowed many more users to build
larger and larger systems. Many of today’s systems are now larger than yesterday’s enterprise class
systems that required mainframe class hardware. This explosion in size and performance is pushing
more users against the limits of the out-of-the-box performance of SQL Server. This means that more
and more SQL Server users are having to start learning about a side of SQL Server that they never
needed to know about — performance tuning.
The good news is that as with the out-of-the-box experience, the SQL Server team has spent a lot of
time working on making SQL Server an easy database system to performance tune. Unlike many
of SQL Server’s competitors, where you need many highly trained and very expensive consultants
to diagnose and finetune performance problems, SQL Server has the tools and information available
so that just about anyone can jump in and start tuning their databases.
time working on making SQL Server an easy database system to performance tune. Unlike many
of SQL Server’s competitors, where you need many highly trained and very expensive consultants
to diagnose and finetune performance problems, SQL Server has the tools and information available
so that just about anyone can jump in and start tuning their databases.
Ar t or Science?
Performance tuning has always had a certain aura of mystique around it. The few masters of the art
are regarded with awe and suspicion by those who haven’t mastered the skills. For those outside the
inner circle of those masters, the perception is that it takes many years to acquire the skills necessary
to become a performance tuner.
are regarded with awe and suspicion by those who haven’t mastered the skills. For those outside the
inner circle of those masters, the perception is that it takes many years to acquire the skills necessary
to become a performance tuner.
The reality is that with a methodical approach, the right tools, and the right knowledge, anyone with
a basic knowledge of T-SQL can start taking steps to improve the performance of their database
system. As you start to master these skills, performance tuning begins to look less like an esoteric
art and more like a focused science.
a basic knowledge of T-SQL can start taking steps to improve the performance of their database
system. As you start to master these skills, performance tuning begins to look less like an esoteric
art and more like a focused science.
This book is about providing you with the knowledge you need to start taking a methodical approach
to performance tuning, to show you which tools to use and when, and to give you the knowledge
you need to be a successful SQL Server performance tuner.
to performance tuning, to show you which tools to use and when, and to give you the knowledge
you need to be a successful SQL Server performance tuner.
COPYRIGHTED MATERIAL