--- title: "Performance Center" description: Find the information that you need about performance in the SQL Server Database Engine and Azure SQL Database. ms.custom: seo-dt-2019 ms.date: "12/11/2018" ms.prod: sql ms.reviewer: "" ms.technology: performance ms.topic: conceptual 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 author: WilliamDAssafMSFT ms.author: wiassaf --- # Performance Center for SQL Server Database Engine and Azure SQL Database [!INCLUDE [SQL Server Azure SQL Database](../../includes/applies-to-version/sql-asdb.md)] This page provides links to help you locate the information that you need about performance in the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] and [!INCLUDE[ssSDSFull](../../includes/sssdsfull-md.md)]. **Legend** ![Screenshot of the legend that explains the feature availability icons.](../../relational-databases/performance/media/security-center-legend.PNG "security-center-legend") ## Configuration Options for Performance [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] provides the ability to affect database engine performance through a number of configuration options at the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] level. With [!INCLUDE[ssSDSFull](../../includes/sssdsfull-md.md)], Microsoft performs most, but not all, of these optimizations for you. |Options|Description| |-|-| |**Disk configuration options**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Disk striping and RAID](https://technet.microsoft.com/library/ms190764\(v=sql.105\).aspx)| |**Data and log file configuration options**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Place Data and Log Files on Separate Drives](../../relational-databases/policy-based-management/place-data-and-log-files-on-separate-drives.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)](../../database-engine/configure-windows/view-or-change-the-default-locations-for-data-and-log-files.md)| |**TempDB configuration options**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Performance Improvements in TempDB](../databases/tempdb-database.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Database Engine Configuration - TempDB](../../database-engine/install-windows/install-sql-server.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions](https://cloudblogs.microsoft.com/sqlserver/2014/09/25/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions/)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Disk and performance best practices for temporary disk for SQL Server in Azure Virtual Machines](/aspnet/core/performance/performance-best-practices)| |**Server Configuration Options**|**Processor configuration options**

:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [affinity mask Server Configuration Option](../../database-engine/configure-windows/affinity-mask-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [affinity Input-Output mask Server Configuration Option](../../database-engine/configure-windows/affinity-input-output-mask-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [affinity64 mask Server Configuration Option](../../database-engine/configure-windows/affinity64-mask-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [affinity64 Input-Output mask Server Configuration Option](../../database-engine/configure-windows/affinity64-input-output-mask-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the max worker threads Server Configuration Option](../../database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option.md)

**Memory configuration options**

:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Server Memory Server Configuration Options](../../database-engine/configure-windows/server-memory-server-configuration-options.md)

**Index configuration options**

:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the fill factor Server Configuration Option](../../database-engine/configure-windows/configure-the-fill-factor-server-configuration-option.md)

**Query configuration options**

:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the min memory per query Server Configuration Option](../../database-engine/configure-windows/configure-the-min-memory-per-query-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the query governor cost limit Server Configuration Option](../../database-engine/configure-windows/configure-the-query-governor-cost-limit-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the max degree of parallelism Server Configuration Option](../../database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Configure the cost threshold for parallelism Server Configuration Option](../../database-engine/configure-windows/configure-the-cost-threshold-for-parallelism-server-configuration-option.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [optimize for ad hoc workloads Server Configuration Option](../../database-engine/configure-windows/optimize-for-ad-hoc-workloads-server-configuration-option.md)

**Backup configuration options**

:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [View or Configure the backup compression default Server Configuration Option](../../database-engine/configure-windows/view-or-configure-the-backup-compression-default-server-configuration-option.md)| |**Database configuration optimization options**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Data Compression](../../relational-databases/data-compression/data-compression.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: [View or Change the Compatibility Level of a Database](../../relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.md)
:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: [ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)](../../t-sql/statements/alter-database-scoped-configuration-transact-sql.md)| |**Table configuration optimization**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Partitioned Tables and Indexes](../../relational-databases/partitions/partitioned-tables-and-indexes.md)| |**Database Engine Performance in an Azure Virtual Machine**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Quick check list](/aspnet/core/performance/performance-best-practices)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Virtual machine size and storage account considerations](/aspnet/core/performance/performance-best-practices)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Disks and performance considerations](/aspnet/core/performance/performance-best-practices)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [I/O Performance Considerations](/aspnet/core/performance/performance-best-practices)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Feature specific performance considerations](/aspnet/core/performance/performance-best-practices)| |**Performance best practices and configuration guidelines for SQL Server on Linux**|:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [SQL Server configuration](../../linux/sql-server-linux-performance-best-practices.md#sql-server-configuration)
:::image type="icon" source="../../relational-databases/performance/media/security-center-sqlserver.png"::: [Linux OS Configuration](../../linux/sql-server-linux-performance-best-practices.md#linux-os-configuration)| > [!IMPORTANT] > Additional considerations are available in: > - [Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads](https://support.microsoft.com/help/2964518) > - [Recommended updates and configuration options for SQL Server 2017 and 2016 with high-performance workloads](https://support.microsoft.com/help/4465518) ## Query Performance Options |Option|Description| |-|-| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Indexes](../../relational-databases/indexes/indexes.md)**|[Reorganize and Rebuild Indexes](../../relational-databases/indexes/reorganize-and-rebuild-indexes.md)
[Specify Fill Factor for an Index](../../relational-databases/indexes/specify-fill-factor-for-an-index.md)
[Configure Parallel Index Operations](../../relational-databases/indexes/configure-parallel-index-operations.md)
[SORT_IN_TEMPDB Option For Indexes](../../relational-databases/indexes/sort-in-tempdb-option-for-indexes.md)
[Improve the Performance of Full-Text Indexes](../../relational-databases/search/improve-the-performance-of-full-text-indexes.md)
[Configure the min memory per query Server Configuration Option](../../database-engine/configure-windows/configure-the-min-memory-per-query-server-configuration-option.md)
[Configure the index create memory Server Configuration Option](../../database-engine/configure-windows/configure-the-index-create-memory-server-configuration-option.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Partitioned Tables and Indexes](../../relational-databases/partitions/partitioned-tables-and-indexes.md)**|[Benefits of Partitioning](../partitions/partitioned-tables-and-indexes.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Joins](../../relational-databases/performance/joins.md)**|[Join Fundamentals](../../relational-databases/performance/joins.md#fundamentals)
[Nested Loops join](../../relational-databases/performance/joins.md#nested_loops)
[Merge join](../../relational-databases/performance/joins.md#merge)
[Hash join](../../relational-databases/performance/joins.md#hash)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Subqueries](../../relational-databases/performance/subqueries.md)**|[Subquery Fundamentals](../../relational-databases/performance/subqueries.md#fundamentals)
[Correlated subqueries](../../relational-databases/performance/subqueries.md#correlated)
[Subquery types](../../relational-databases/performance/subqueries.md#types)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Stored Procedures](../stored-procedures/stored-procedures-database-engine.md)**|[CREATE PROCEDURE (Transact-SQL)](../../t-sql/statements/create-procedure-transact-sql.md#best-practices)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[User-Defined Functions](../user-defined-functions/user-defined-functions.md)**|[CREATE FUNCTION (Transact-SQL)](../../t-sql/statements/create-function-transact-sql.md#best-practices)
[Create User-defined Functions (Database Engine)](../user-defined-functions/create-user-defined-functions-database-engine.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **Parallelism optimization**|[Configure the max worker threads Server Configuration Option](../../database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option.md)
[ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)](../../t-sql/statements/alter-database-scoped-configuration-transact-sql.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **Query optimizer optimization**|[ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)](../../t-sql/statements/alter-database-scoped-configuration-transact-sql.md)
[USE HINT query hint](../../t-sql/queries/hints-transact-sql-query.md#use_hint)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Statistics](../../relational-databases/statistics/statistics.md)**|[When to Update Statistics](../statistics/statistics.md)
[Update Statistics](../../relational-databases/statistics/update-statistics.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[In-Memory OLTP (In-Memory Optimization)](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md)**|[Memory-Optimized Tables](../in-memory-oltp/sample-database-for-in-memory-oltp.md)
[Natively Compiled Stored Procedures](../in-memory-oltp/a-guide-to-query-processing-for-memory-optimized-tables.md)
[Creating and Accessing Tables in TempDB from Natively Compiled Stored Procedures](../../relational-databases/in-memory-oltp/create-and-access-tables-in-tempdb-from-stored-procedures.md)
[Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes](/previous-versions/sql/sql-server-2016/dn589805(v=sql.130))
[Demonstration: Performance Improvement of In-Memory OLTP](../../relational-databases/in-memory-oltp/demonstration-performance-improvement-of-in-memory-oltp.md)| |:::image type="icon" source="../../relational-databases/performance/media/security-center-both.png"::: **[Intelligent query processing](../../relational-databases/performance/intelligent-query-processing.md)**|[Intelligent query processing](../../relational-databases/performance/intelligent-query-processing.md)| ## See Also [Monitor and Tune for Performance](../../relational-databases/performance/monitor-and-tune-for-performance.md) [Monitoring Performance By Using the Query Store](../../relational-databases/performance/monitoring-performance-by-using-the-query-store.md) [Azure SQL Database performance guidance for single databases](/azure/azure-sql/database/performance-guidance) [Optimizing Azure SQL Database Performance using Elastic Pools](/azure/azure-sql/database/elastic-pool-overview) [Query Performance Insight for Azure SQL Database](/azure/azure-sql/database/query-performance-insight-use) [Index Design Guide](../../relational-databases/sql-server-index-design-guide.md) [Memory Management Architecture Guide](../../relational-databases/memory-management-architecture-guide.md) [Pages and Extents Architecture Guide](../../relational-databases/pages-and-extents-architecture-guide.md) [Post-migration Validation and Optimization Guide](../../relational-databases/post-migration-validation-and-optimization-guide.md) [Query Processing Architecture Guide](../../relational-databases/query-processing-architecture-guide.md) [SQL Server Transaction Locking and Row Versioning Guide](../sql-server-transaction-locking-and-row-versioning-guide.md) [SQL Server Transaction Log Architecture and Management Guide](../../relational-databases/sql-server-transaction-log-architecture-and-management-guide.md) [Thread and Task Architecture Guide](../../relational-databases/thread-and-task-architecture-guide.md)