Seagate ST43401N/ND Guia de Instalação descarregar pdf (Página 89)

CHAPTER 7 Test: Ensuring Stability and Performance

Use backups or the

bcp scripts to populate your test databases.

Note When you create a new database and then load bcp files, 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 Create the database with the

for load option of the create database

command.

2 Load the backups you made of the production database.

3Issue the

online database command. This command automatically

upgrades the database if it is not at the 12.5 level.

For command syntax, see the Reference Manual at

http://manuals.sybase.com:80/onlinebooks/group-

as/asg1250e/refman/@Generic__BookView

If the Test Environment Is Not an Exact Duplicate

If you have to use a smaller system for testing, try to have components identical

to the production system, such as operating system level, drivers, and disk

types.

1 2 ... 84 85 86 87 88 89 90 91 92 93 94 ... 145 146

Sem comentários

Seagate ST43401N/ND Guia de Instalação Página 89