Dell H730P Manual de usuario descargar pdf (Pagina 15)

A Principled Technologies test report 15

Database performance and resiliency in the Intel processor-powered

Dell PowerEdge R630 running Microsoft SQL Server 2014

1. We generated the data and created the database and file structure using database creation scripts in the

DS2 download. We made size modifications specific to our 40GB database and the appropriate changes to

drive letters.

2. We transferred the files from our Linux data generation system to a Windows system running SQL Server.

3. We created database tables, stored procedures, and objects using the provided DVD Store scripts.

4. We set the database recovery model to bulk-logged to prevent excess logging.

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 8 shows our initial file size modifications.

1 2 ... 10 11 12 13 14 15 16 17 18

Sin comentarios

Dell H730P Manual de usuario Pagina 15