Dell 800 Dokumentacja Pobierz pdf (Strona 43)

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]

CREATE LOGIN [ds2user] WITH PASSWORD=N’’,

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english],

CHECK_EXPIRATION=OFF,

CHECK_POLICY=OFF

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

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.

1 2 ... 38 39 40 41 42 43 44 45 46

Komentarze do niniejszej Instrukcji

Brak uwag

Dell 800 Dokumentacja Strona 43

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Serwery Dell 800