performance-center-for-sql-server-database-engine-and-azure-sql-database.md

title	Performance Center for SQL Server Database Engine and Azure SQL Database | Microsoft Docs
ms.custom	MSDN content MSDN - SQL DB
ms.date	04/08/2016
ms.prod	sql-non-specified
ms.reviewer
ms.service	sql-database
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
f1_keywords	Performance (SQL Server) Performance (SQL Database)
helpviewer_keywords	SQL Server, performance performance (SQL Server) database performance (SQL Server) SQL Database (Performance) performance (SQL Database) database performance (SQL Database)
ms.assetid	301204b2-140d-4495-98ed-021a9b5025f5
caps.latest.revision	14
author	CarlRabeler
ms.author	carlrab
manager	jhubbard

Performance Center for SQL Server Database Engine and Azure SQL Database

This page provides links to help you locate the information that you need about performance in the [!INCLUDEssDEnoversion] and [!INCLUDEssSDSFull].

Legend

This is a work in process. Does this Performance Center help you? How can we improve it?

What information are you looking for, and did you find it? What are we missing? What would you like to see here? We’re listening to your feedback to improve the content. Please submit your comments to sqlfeedback@microsoft.com

Configuration Options for Performance

[!INCLUDEssNoVersion] provides the ability to affect database engine performance through a number of configuration options at the [!INCLUDEssDEnoversion] level. With [!INCLUDEssSDSFull], Microsoft performs most, but not all, of these optimizations for you.

Disk configuration options	- Disk striping and RAID
Data and log file configuration options	- Place Data and Log Files on Separate Drives - View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)
TempDB configuration options	- Performance Improvements in TempDB - Database Engine Configuration - TempDB - Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions - Disk and performance best practices for temporary disk for SQL Server in Azure Virtual Machines
Server Configuration Options	Processor configuration options affinity mask Server Configuration Option affinity Input-Output mask Server Configuration Option affinity64 mask Server Configuration Option affinity64 Input-Output mask Server Configuration Option Configure the max worker threads Server Configuration Option Memory configuration options Server Memory Server Configuration Options Index configuration options Configure the fill factor Server Configuration Option Query configuration options Configure the min memory per query Server Configuration Option Configure the query governor cost limit Server Configuration Option Configure the max degree of parallelism Server Configuration Option Configure the cost threshold for parallelism Server Configuration Option optimize for ad hoc workloads Server Configuration Option Backup configuration options View or Configure the backup compression default Server Configuration Option
Database configuration optimization options	- Data Compression - View or Change the Compatibility Level of a Database - ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
Table configuration optimization	- Partitioned Tables and Indexes -
Database Engine Performance in an Azure Virtual Machine	- Quick check list - Virtual machine size and storage account considerations - Disks and performance considerations - I/O Performance Considerations - Feature specific performance considerations

Query Performance Options

Indexes	- Reorganize and Rebuild Indexes - Specify Fill Factor for an Index - Configure Parallel Index Operations - SORT_IN_TEMPDB Option For Indexes - Improve the Performance of Full-Text Indexes
Partitioned Tables and Indexes	- Benefits of Partitioning
Stored Procedures	- Benefits of Stored Procedures
User-Defined Functions	- User-defined Function Benefits
Parallelism optimization	- Configure the max worker threads Server Configuration Option - ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
Query optimizer optimization	- ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)
Statistics	- When to Update Statistics - Update Statistics
In-Memory OLTP (In-Memory Optimization)	- Memory-Optimized Tables - Natively Compiled Stored Procedures - Creating and Accessing Tables in TempDB from Natively Compiled Stored Procedures - Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes - Demonstration: Performance Improvement of In-Memory OLTP

See Also

Monitor and Tune for Performance
Monitoring Performance By Using the Query Store
Azure SQL Database performance guidance for single databases
Optimizing Azure SQL Database Performance using Elastic Pools
Azure Query Performance Insight