White Papers

Install and configure SQL Server 2017 Enterprise Edition
22 Deploying the 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL
7.3.5 Expand tempdb files
1. Click New Query on the toolbar.
2. Enter the following T-SQL commands to expand the existing tempdb files, replacing <log file size>
and <data file size> with the appropriate file size:
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'templog',
SIZE = <log file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'tempdev',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp2',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp3',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp4',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp5',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp6',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp7',
SIZE = <data file size> )
ALTER DATABASE tempdb MODIFY FILE
( NAME = N'temp8',
SIZE = <data file size> )
3. Click !Execute on the toolbar.