In this video you will learn how to reduce TempDB size without restarting SQL Server Services? Video explains couple ways to do it,
1- Using SQL Server Management Studio
2- Using T-Script
It also walks you through where these methods of reducing TempDB size might not work and best practices of shrinking TempDB Files.
Scripts:
1- Using SQL Server Management Studio
2- Using T-Script
It also walks you through where these methods of reducing TempDB size might not work and best practices of shrinking TempDB Files.
Scripts:
USE [tempdb] GO --10 is desired size in MB, keep in mind that this size needs to be more than or equal to minimum required --size of tempdb, otherwise tempdb will not shrink DBCC SHRINKFILE (N'tempdev' , 10) GO
Reduce TempDB Size without Restarting SQL Server Services - SQL Server DBA Tutorial
No comments:
Post a Comment