Dell PowerEdge M420 Bedienungsanleitung PDF herunterladen (Seite 13)

A Principled Technologies test report 13

Blade server database performance: Dell PowerEdge M420

3. Proceed through the first introductory screens to specify product key, license agreement, and setup support

rules.

4. On the Cluster Node Configuration screen, choose the SQL Server instance that you wish to add the node to, and

click Next.

5. On the Cluster Network Configuration screen, select the network settings you wish to use, and click Next.

6. On the Service Accounts screen, fill in Active Directory authentication details, and click Next.

7. On the Error Reporting screen, click next.

8. On the Add Node Rules screen, click Next.

9. On the Ready to Add Node screen, click Install.

Configuring the database (DVD Store)

Data generation overview

We generated data using the Install.pl script included with DVD Store version 2.1 (DS2), providing the

parameters for our 40GB database size and the database platform on which we ran, Microsoft SQL Server. We ran the

Install.pl script on a utility system running Linux. The database schema was also generated by the Install.pl script.

After processing the data generation, we transferred the data files and schema creation files to a Windows-

based system running SQL Server 2008 R2 SP1. We built the 40GB database in SQL Server 2012, and then performed a

full backup, storing the backup file on shared storage LUN we designated for backup storage. We used that backup file

to restore on all instances between test runs. We performed this procedure once, and used the same backup file for all

both nodes in all three test runs.

The only modification we made to the schema creation scripts were the specified file sizes for our database. We

explicitly set the file sizes higher than necessary to ensure that no file-growth activity would affect the outputs of the

test, allowing for approximately 40 percent free space in the database files. Besides this file size modification, the

database schema was created and loaded according to the DVD Store documentation. Specifically, we followed the

steps below:

1. Generate the data and create 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. Transfer the files from our Linux data generation system to a Windows system running SQL Server.

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

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

5. Load 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. Create indices, full-text catalogs, primary keys, and foreign keys using the database-creation scripts.

7. Update statistics on each table according to database-creation scripts, which sample 18 percent of the table

data.

8. On the SQL Server instance, create 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],

1 2 ... 8 9 10 11 12 13 14 15

Kommentare zu diesen Handbüchern

Keine Kommentare

Dell PowerEdge M420 Bedienungsanleitung Seite 13

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Vernetzung Dell PowerEdge M420