SQL Server 数据库引擎和 Azure SQL 数据库的性能中心Performance Center for SQL Server Database Engine and Azure SQL Database

适用对象:是SQL Server 是Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

本页提供的链接可帮助你找到有关 SQL Server 数据库引擎SQL Server Database EngineAzure SQL DatabaseAzure SQL Database中的性能的必要信息。This page provides links to help you locate the information that you need about performance in the SQL Server 数据库引擎SQL Server Database Engine and Azure SQL DatabaseAzure SQL Database.

图例Legend

security-center-legendsecurity-center-legend

性能的配置选项Configuration Options for Performance

SQL ServerSQL Server 通过许多 SQL Server 数据库引擎SQL Server Database Engine 级别的配置选项,提供了可影响数据库引擎性能的功能。provides the ability to affect database engine performance through a number of configuration options at the SQL Server 数据库引擎SQL Server Database Engine level. 通过 Azure SQL DatabaseAzure SQL Database,Microsoft 可为你执行这些优化中的大多数(不是全部)。With Azure SQL DatabaseAzure SQL Database, Microsoft performs most, but not all, of these optimizations for you.

磁盘配置选项Disk configuration options security-center-sqlserver 磁盘条带化和 RAIDsecurity-center-sqlserver Disk striping and RAID
数据和日志文件配置选项Data and log file configuration options security-center-sqlserver 将数据和日志文件放到不同的驱动器上security-center-sqlserver Place Data and Log Files on Separate Drives
security-center-sqlserver 查看或更改数据文件和日志文件的默认位置 (SQL Server Management Studio)security-center-sqlserver View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)
TempDB 配置选项TempDB configuration options security-center-sqlserver TempDB 的性能提高security-center-sqlserver Performance Improvements in TempDB
security-center-sqlserver 数据库引擎配置 - TempDBsecurity-center-sqlserver Database Engine Configuration - TempDB
security-center-sqlserver Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions(使用 Azure VM 中的 SSD 存储 SQL Server TempDB 和缓冲池扩展)security-center-sqlserver Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions
security-center-sqlserver Azure 虚拟机中 SQL Server 的临时磁盘的磁盘和性能最佳实践security-center-sqlserver Disk and performance best practices for temporary disk for SQL Server in Azure Virtual Machines
服务器配置选项Server Configuration Options 处理器配置选项Processor configuration options

security-center-sqlserver “关联掩码”服务器配置选项security-center-sqlserver affinity mask Server Configuration Option
security-center-sqlserver “关联 I/O 掩码”服务器配置选项security-center-sqlserver affinity Input-Output mask Server Configuration Option
security-center-sqlserver “Affinity64 掩码”服务器配置选项security-center-sqlserver affinity64 mask Server Configuration Option
security-center-sqlserver “Affinity64 I/O 掩码”服务器配置选项security-center-sqlserver affinity64 Input-Output mask Server Configuration Option
security-center-sqlserver 配置“最大工作线程”服务器配置选项security-center-sqlserver Configure the max worker threads Server Configuration Option

内存配置选项Memory configuration options

security-center-sqlserver “服务器内存”服务器配置选项security-center-sqlserver Server Memory Server Configuration Options

索引配置选项Index configuration options

security-center-sqlserver 配置“填充因子”服务器配置选项security-center-sqlserver Configure the fill factor Server Configuration Option

查询配置选项Query configuration options

security-center-sqlserver 配置“每次查询占用的最小内存”服务器配置选项security-center-sqlserver Configure the min memory per query Server Configuration Option
security-center-sqlserver 配置“查询调控器开销限制”服务器配置选项security-center-sqlserver Configure the query governor cost limit Server Configuration Option
security-center-sqlserver 配置“最大并行度”服务器配置选项security-center-sqlserver Configure the max degree of parallelism Server Configuration Option
security-center-sqlserver 配置“并行的开销阈值”服务器配置选项security-center-sqlserver Configure the cost threshold for parallelism Server Configuration Option
security-center-sqlserver “针对即席工作负荷进行优化”服务器配置选项security-center-sqlserver optimize for ad hoc workloads Server Configuration Option

备份配置选项Backup configuration options

security-center-sqlserver 查看或配置“备份压缩默认值”服务器配置选项security-center-sqlserver View or Configure the backup compression default Server Configuration Option
数据库配置优化选项Database configuration optimization options security-center-sqlserver 数据压缩security-center-sqlserver Data Compression
security-center-both 查看或更改数据库的兼容级别security-center-both View or Change the Compatibility Level of a Database
security-center-both ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)security-center-both ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
表配置优化Table configuration optimization security-center-sqlserver 已分区表和已分区索引security-center-sqlserver Partitioned Tables and Indexes
Azure 虚拟机中的数据库引擎性能Database Engine Performance in an Azure Virtual Machine security-center-sqlserver 快速检查列表security-center-sqlserver Quick check list
security-center-sqlserver 虚拟机大小和存储帐户注意事项security-center-sqlserver Virtual machine size and storage account considerations
security-center-sqlserver 磁盘和性能注意事项security-center-sqlserver Disks and performance considerations
security-center-sqlserver I/O 性能注意事项security-center-sqlserver I/O Performance Considerations
security-center-sqlserver 功能特定的性能注意事项security-center-sqlserver Feature specific performance considerations
性能最佳做法和 Linux 上的 SQL Server 的配置准则Performance best practices and configuration guidelines for SQL Server on Linux security-center-sqlserver SQL Server 配置security-center-sqlserver SQL Server configuration
security-center-sqlserver Linux OS 配置security-center-sqlserver Linux OS Configuration

查询性能选项Query Performance Options

security-center-both 索引 security-center-both Indexes 重新组织和重新生成索引Reorganize and Rebuild Indexes
为索引指定填充因子Specify Fill Factor for an Index
配置并行索引操作Configure Parallel Index Operations
用于索引的 SORT_IN_TEMPDB 选项SORT_IN_TEMPDB Option For Indexes
改进全文索引的性能Improve the Performance of Full-Text Indexes
配置“每次查询占用的最小内存”服务器配置选项Configure the min memory per query Server Configuration Option
配置 index create memory 服务器配置选项Configure the index create memory Server Configuration Option
security-center-both 已分区表和已分区索引 security-center-both Partitioned Tables and Indexes 分区的优点Benefits of Partitioning
security-center-both 联接security-center-both Joins 联接基础知识Join Fundamentals
嵌套循环联接Nested Loops join
合并联接Merge join
联接Hash join
security-center-both 子查询security-center-both Subqueries 子查询基础知识Subquery Fundamentals
相关子查询Correlated subqueries
子查询类型Subquery types
security-center-both 存储过程 security-center-both Stored Procedures CREATE PROCEDURE (Transact-SQL)CREATE PROCEDURE (Transact-SQL)
security-center-both 用户定义函数 security-center-both User-Defined Functions CREATE FUNCTION (Transact-SQL)CREATE FUNCTION (Transact-SQL)
创建用户定义函数(数据库引擎)Create User-defined Functions (Database Engine)
security-center-both 并行优化security-center-both Parallelism optimization 配置 max worker threads 服务器配置选项Configure the max worker threads Server Configuration Option
ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
security-center-both 查询优化器优化security-center-both Query optimizer optimization ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
USE HINT 查询提示USE HINT query hint
security-center-both 统计信息 security-center-both Statistics 何时更新统计信息When to Update Statistics
更新统计信息Update Statistics
security-center-both 内存中 OLTP(内存中优化)security-center-both In-Memory OLTP (In-Memory Optimization) Memory-Optimized TablesMemory-Optimized Tables
本机编译的存储过程Natively Compiled Stored Procedures
通过本机编译的存储过程创建和访问 TempDB 中的表Creating and Accessing Tables in TempDB from Natively Compiled Stored Procedures
对内存优化哈希索引的常见性能问题进行故障排除Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes
演示:内存中 OLTP 的性能改进Demonstration: Performance Improvement of In-Memory OLTP
security-center-both 智能查询处理security-center-both Intelligent query processing 智能查询处理Intelligent query processing

另请参阅See Also

监视和优化性能 Monitor and Tune for Performance
使用查询存储来监视性能 Monitoring Performance By Using the Query Store
单一数据库的 Azure SQL 数据库性能指南 Azure SQL Database performance guidance for single databases
使用弹性池优化 Azure SQL 数据库性能 Optimizing Azure SQL Database Performance using Elastic Pools
Azure 查询性能见解Azure Query Performance Insight
索引设计指南Index Design Guide
内存管理体系结构指南Memory Management Architecture Guide
页和区体系结构指南Pages and Extents Architecture Guide
迁移后验证和优化指南Post-migration Validation and Optimization Guide
查询处理体系结构指南Query Processing Architecture Guide
SQL Server 事务锁定和行版本控制指南SQL Server Transaction Locking and Row Versioning Guide
SQL Server 事务日志体系结构和管理指南SQL Server Transaction Log Architecture and Management Guide
线程和任务体系结构指南Thread and Task Architecture Guide