Database Reference
In-Depth Information
Make sure your network supports the larger packet sizes. Improper
configuration can cause performance problems. DBAs and VMware admins
should work with the Network team to understand the appropriate
Repeat this step for all SQL Server virtual machines.
Creating Multiple tempdb Files
A recommendation Microsoft makes around the tempdb database is to create one data
file per CPU. This is a setting you will want to work with the DBA team on because
some systems may benefit from this setting and other systems will not. In addition, test
for diminishing returns, meaning that after “x” number of additional tempdb data files,
there is no benefit to performance. See
Chapter 6
for more information.
Note
More information on the Instant File Initialization setting can be found at
On the SQL Server virtual machines, open the
SQL Server Management Studio
,
expand
Databases
, expand
System Databases
, and click
tempdb
. Right-click
tempdb
and select
Properties
. Once the
Database Properties - tempdb
dialog box opens, click
Files
(located on the left). Then click
Add
and enter the proper number of additional
tempdb data files.
Figure 11.68
displays the tempdb configuration we used in our lab.
When you are done configuring your tempdb files, click
OK
to build the files and close
the dialog box.