From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Prevent excessive tempdb autogrowth - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Prevent excessive tempdb autogrowth
- [Instructor] Whenever your SQL server instances restarted, the system database tempdb is recreated. If your workload requires a large amount of space in tempdb to function efficiently, then you might be hitting a bottleneck of tempdb being too small and having to auto grow to an appropriate size every time the server restarts. You could minimize this disruption by resizing tempdb to a more appropriate size for your usage. Let's go ahead and right click on tempdb and take a look at its properties. My temp database is currently 24 megabytes in size and I can see that here on the general page. This 24 megabytes is split up across three different files and if I switch over here to the files tab I can see them right here and they're all set at eight megabytes. Now if you're finding that this is too small for your needs you can increase the initial size of tempdb just by simply increasing the size here. In fact I'm going to change all of these up to 100 megabytes. We can also adjust their…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.