System information

A Principled Technologies test report 34
Comparing performance and cost: Dell PowerEdge VRTX vs.
legacy hardware solution
USE [master]
GO
CREATE LOGIN [ds2user] WITH PASSWORD=N’’,
DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF
GO
9. We set the database recovery model back to full.
10. We created the necessary full text index using SQL Server Management Studio.
11. We created a database user and mapped this user to the SQL Server login.
12. We then performed a full backup of the database. This backup allowed us to restore the databases to a
pristine state relatively quickly between tests.
Figure 13 shows our initial file size modifications.
Logical name
Filegroup
Initial size (MB)
Database files
primary
PRIMARY
3.25
cust1
DS_CUST_FG
5,767
cust2
DS_CUST_FG
5,767
ind1
DS_IND_FG
2,621
ind2
DS_IND_FG
2,621
ds_misc
DS_MISC_FG
2,621
orders1
DS_ORDERS
2,621
orders2
DS_ORDERS
2,621
Log files
ds_log
Not Applicable
20,480
Figure 13: Our initial file size modifications.
Installing and configuring Iometer
We installed Iometer on a VM residing on the second Dell PowerEdge M620 and on the HP ProLiant ML110 G6.
Configuring the Iometer VM (VRTX only)
After cloning, modify the Iometer VM to contain the following settings:
o Memory: 8GB
o Virtual Processors: 4
o Additional virtual disks:
 1 x 50GB virtual disk for Iometer target (Thick provisioned, eager-zeroed)
Configuring the legacy machine (legacy only)
1. Log into Windows using the appropriate credentials.