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/relat...
Improve SQL Managed Instance performance with new tempdb configurations: https://techcommunity.microsoft.com/t...
Configure tempdb max size in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t...
User-initiated manual failover on SQL Managed Instance: https://learn.microsoft.com/azure/azu...
Azure SQL Managed Instance resource limits: https://learn.microsoft.com/azure/azu...
What's new in Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
2022 - a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t...