Sql Server 2000 Advanced Performance Tuning & Optimization Guidebook.pdf

Guidebook
SQL Server 2000 Advanced
Performance Tuning & Optimization
SQL Server 2000 Architecture 1




SQL Server 2000
Architecture
Contents
Overview 4
SQL Server Architecture 5
Client-ponents 7
Client-munication Process 9
Data Access Memory and Disk 10
When a query runs… 11
2 SQL Server 2000 Architecture



© 2006 Microsoft Corporation. All rights reserved.

The information contained in this document represents the current view of Microsoft Corporation
on the issues discussed as of the date of publication. Because Microsoft must respond to changing
market conditions, it should not be interpreted to be mitment on the part of Microsoft, and
Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES,
EXPRESS OR IMPLIED, IN THIS DOCUMENT.

Microsoft is a registered trademark of Microsoft in the United States and/or other countries.

Fictitious Disclaimer:

The panies, organizations, products, domain names, e-mail addresses, logos, people,
places, and events depicted herein are fictitious. No association with any pany,
organization, product, domain name, email address, logo, person, places, or events is intended or
should be inferred.
SQL Server 2000 Architecture 3

Overview


This class focuses on Microsoft ® SQL™ Server architectural concepts,
performance data collection tools, and data analysis methods. Understanding
SQL Server architecture will form the basis for learning advanced
troubleshooting techniques.
Later modules will cover topics such as query tuning and the Performance
Monitor (Perfmon). Without a solid understanding of how SQL Server works,
these efforts are less productive. The overall goal of this class is to provide the
skills needed to identify and tune hot spots before critical situations occur.
4 SQL Server