Seagate ST43401N/ND Informações Técnicas descarregar pdf (Página 102)

7-2 Test: Ensuring Stability and Performance

Setting Up the Test Environment Adaptive Server Enterprise 11.5

Setting Up the Test Environment

Ideally, you should set up a dedicated hardware conﬁguration

(including subnets) and SQL Server exactly like your production

system. Creating an identical system lets you make valid

comparison, perform real tuning as part of migration effort, and if

you wish to do so, switch the test system to production later on.

Make Backups

Make backups of the production system. You can use these to

populate your test system and to restore it when necessary.

Use Scripts to Create the Test System

Using the object creation scripts you gathered, wrote or reverse

engineered in Chapter 3, “Analyze: Documenting Your

Environment”, build a test environment matching your production

system.

Use backups or the

bcp scripts to populate your test databases.

➤

Note

When you create a new database and then load bcp ﬁles, you reduce the

fragmentation that may be present in the production system and change the

performance characteristics of the database. If this is not desirable because

you do not intend to rebuild your production environment, you may prefer to

create your databases as described in the next section, “Create Your

Databases by Loading Backups”.

Run dbcc’s in the test databases immediately to be sure that there are

no problems at this stage.

Create Your Databases by Loading Backups

If you do not intend to rebuild your production environment, you

may prefer to create your test databases with the

for load option of the

create database command. This makes your test databases more

representative of the current production environment in terms of

fragmentation and density.

Follow these steps:

1 2 ... 97 98 99 100 101 102 103 104 105 106 107 ... 171 172

Sem comentários

Seagate ST43401N/ND Informações Técnicas Página 102