Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Performance Center for SQL Server Database Engine and Azure SQL Database
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database
This page provides links to help you locate the information that you need about performance in the SQL Server Database Engine and Azure SQL Database.
Legend
👁 Screenshot of the legend that explains the feature availability icons.
Configuration options for performance
SQL Server provides the ability to affect database engine performance through a number of configuration options at the SQL Server Database Engine level. With Azure SQL Database, Microsoft performs most, but not all, of these optimizations for you.
Important
Additional considerations are available in:
Query Performance Options
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
- Query Performance Insight for Azure SQL Database
- Index Design Guide
- Memory Management Architecture Guide
- Pages and Extents Architecture Guide
- Post-migration Validation and Optimization Guide
- Query Processing Architecture Guide
- SQL Server Transaction Locking and Row Versioning Guide
- SQL Server Transaction Log Architecture and Management Guide
- Thread and Task Architecture Guide
Feedback
Was this page helpful?