694 lines (693 loc) · 38.5 KB

layout

HubPage

hide_bc

true

experimental

true

experiment_id

81ba5f65-59fb-4d

title

Microsoft Azure Documentation

description

Learn how to build and manage powerful applications using Microsoft Azure cloud services. Get documentation, example code, tutorials, and more.

ms.topic

hub-page

ms.prod

sql

author

MashaMSFT

ms.author

mathoma

manager

craigg

ms.date

12/15/2018

featureFlags

clicktale

SQL Server: Education Center

Quickstarts

Tutorials

SQL Internals Guides

Ghost record cleanup process

Provides an overview of the background process that deletes records off of pages that have been marked for deletion.
Index architecture and design

Contains information on index architecture, and best practices to help you design effective indexes.
Memory management architecture

Explains how SQL Server manages memory, as well as memory utilization while reading and writing pages.
Pages and extents architecture

Describes the data structures that are used to manage pages and extents in all versions of SQL Server.
Post-migration validation and optimization

An overview of some common performance scenarios encountered after migrating to SQL Server and how to resolve them.
Query processing architecture

Covers how SQL Server processes queries and optimizes query reuse through execution plan caching.
Transaction log architecture and management

Provides information about the physical and logical architecture of the transaction log.
Thread and task architecture

Explains how SQL manipulates threads and tasks, which help dictate application logic and execution paths.
Transaction locking and row versioning

Describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction.

Additional Resources

Keep in touch with us