Configure tempdb for improved performance

SQL Server instance, as well as Azure SQL Managed Instance, comes with four system databases by default, one of which is tempdb. Tempdb is used for non-durable storage and therefore the transactions are minimally logged, and this gives opportunity for better performance for some types of workloads. In this video you will see how you can configure the number of tempdb files and their growth increments to tune your instance performance and adjust it for the types of workloads you're running. Tempdb configurations as well as the snapshot isolation property for tempdb will be persisted upon a server restart, a resize management operation or a failover. Chapters: 00:08 Introduction 00:18 Configure number of tempdb files (add/remove files) 02:20 Configure growth increments for tempdb files 04:10 Tempdb configurations summary Recommended content: Tempdb database: https://learn.microsoft.com/sql/relational-databases/databases/tempdb-database Improve SQL Managed Instance performance with new tempdb configurations: https://techcommunity.microsoft.com/t5/azure-sql-blog/improve-your-sql-managed-instance-performance-with-new-tempdb/ba-p/3640094 Configure tempdb max size in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/configure-your-tempdb-max-size-in-azure-sql-managed-instance/ba-p/3715655 User-initiated manual failover on SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/user-initiated-failover Azure SQL Managed Instance resource limits: https://learn.microsoft.com/azure/azure-sql/managed-instance/resource-limits What's new in Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview 2022 - a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/2022-a-year-of-unparalleled-innovation-in-azure-sql-managed/ba-p/3676757