Databases Reference
In-Depth Information
1
SQL Server Architecture
WHAT'S IN THIS CHAPTER?
➤
Understanding database transactions and the ACID properties
➤
Architectural components used to fulfi ll a read request
➤
Architectural components used to fulfi ll an update request
➤
Database recovery and the transaction log
➤
Dirty pages, checkpoints, and the lazy writer
➤
Where the SQLOS fi ts in and why it's needed
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The
wrox.com
code downloads for this chapter are found at
www.wrox.com/remtitle
.cgi?isbn=1118177657
on the Download Code tab. The code is in the Chapter 1 download
and individually named according to the names throughout the chapter.
INTRODUCTION
A basic grasp of SQL Server's database engine architecture is fundamental to intelligently
approach troubleshooting a problem, but selecting the important bits to learn about can
be challenging, as SQL Server is such a complex piece of software. This chapter distills the
core architecture of SQL Server, putting the most important components into the context of
executing a simple query to help you understand the fundamentals of the core engine.
You will learn how SQL Server deals with your network connection, unravels what you're
asking it to do, decides how it will execute your request, and i nally how data is retrieved and
modii ed on your behalf.
Search WWH ::
Custom Search