Dell PowerEdge R940 Deploying the 385TB Data Warehouse Fast Track Reference Ar - Page 23
Expand tempdb files
View all Dell PowerEdge R940 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 23 highlights
Install and configure Microsoft SQL Server 2017 Enterprise Edition 7.3.6 Expand tempdb files 1. Click New Query on the toolbar. 2. Enter the following T-SQL commands to expand the existing tempdb files, replacing and with the appropriate file size: ALTER DATABASE tempdb MODIFY FILE ( NAME = N'templog', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'tempdev', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp2', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp3', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp4', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp5', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp6', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp7', SIZE = ) ALTER DATABASE tempdb MODIFY FILE ( NAME = N'temp8', SIZE = ) 3. Click Execute on the toolbar. 23 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4033-CD-SQL