Specifications
A Principled Technologies test report 43
Dell Active System 800 converged infrastructure solution: User
collaboration performance
5. We loaded the data we generated into the database. For data loading, we used the import wizard in SQL Server
Management Studio. Where necessary, we retained options from the original scripts, such as Enable Identity
Insert.
6. We created indices, full-text catalogs, primary keys, and foreign keys using the database-creation scripts.
7. We updated statistics on each table according to database-creation scripts, which sample 18 percent of the
table data.
8. On the SQL Server instance, we created a ds2user SQL Server login using the following Transact SQL (TSQL)
script:
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 9 shows our initial file size modifications.
Logical name
Filegroup
Initial size (MB)
Database files
primary
PRIMARY
2
cust1
DS_CUST_FG
12,288
cust2
DS_CUST_FG
12,288
cust3
DS_CUST_FG
12,288
cust4
DS_CUST_FG
12,288
ind1
DS_IND_FG
5,355
ind2
DS_IND_FG
5,355
ind3
DS_IND_FG
5,355
ind4
DS_IND_FG
5,355
ds_misc
DS_MISC_FG
200
orders1
DS_ORDERS
6,144
orders2
DS_ORDERS
6,144
orders3
DS_ORDERS
6,144
orders4
DS_ORDERS
6,144
Log files
ds_log
Not Applicable
20,480
Figure 9. Our initial file size modifications.