Dell PowerEdge R640 Deploying the 55TB Data Warehouse Fast Track Reference Arc - Page 22

Expand tempdb files

Get Dell PowerEdge R640 PDF manuals and user guides View all Dell PowerEdge R640 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 22 highlights

Install and configure SQL Server 2017 Enterprise Edition 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 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. 22 Deploying the 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
Install and configure SQL Server 2017 Enterprise Edition
22
Deploying the 55TB 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.