File system configuration

For more information, see:

Write pages in the Database Engine

Read data pages in the Database Engine

The following table provides links to additional information for specific I/O configurations.

File system features

databases aren’t supported on compressed volumes, except for

read-only files. For more information, see:

Description of support for SQL Server databases on compressed volumes

Decreased performance in SQL Server when you use EFS to encrypt database

files

Physical Database Storage Design

Scalable Shared Databases Overview

Microsoft SQL Server I/O subsystem requirements for the tempdb database

Recommendations to reduce allocation contention in SQL Server tempdb

database

Asynchronous disk I/O appears as synchronous on Windows

diagnostics detects unreported I/O problems due to stale reads or

lost writes

MSSQLSERVER error 823

Description of support for network database files in SQL Server

Prerequisites, restrictions, and recommendations for Always On availability

groups

Always On failover cluster instances

Page and extent architecture guide

Memory management architecture guide

you to reproduce the issue without the third-party product before continuing the

investigation.

ﾉ

Expand table