Seagate ST43401N/ND Technical Information PDF herunterladen (Seite 103)

Migrating to Sybase Adaptive Server Enterprise 11.5 7-3

Adaptive Server Enterprise 11.5 Prioritizing Applications to be Tested

1. Create the database with the for load option of the create database

command.

2. Load the backups you made of the production database.

3. Issue the

online database command. This command automatically

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

The

online database command was added in SQL Server 11.0. For

command syntax, see the Reference Manual.

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.

You have to make adjustments when you have less disk space or

memory in the test system. Scale down databases proportionally,

while retaining the same data distributions so optimizer decisions

remain constant. Scale down memory to ensure consistent I/O rates.

Reproduce data layout across available devices as closely as possible.

If you use fewer CPUs, adjust transaction arrival rates (that is, load)

and concurrent users proportionally.

Prioritizing Applications to be Tested

Since it may be difﬁcult to test all application functions, gather user

input to identify the most critical transactions. Write tests for those

functions using the techniques described in the following sections.

Functions not tested at this time can be validated during user

acceptance tests.

Establishing Performance Criteria

Depending on the migration plan you developed, you may want

to meet or exceed the performance you get with your current

system. For example, you might decide to apply guidelines like

these:

• For parallel with replication:

- Be sure to measure the overhead of the replication mechanism.

For example, if the replication costs 10%, do not begin parallel

operations until release 11.5 is tuned to outperform by 10%.

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

Keine Kommentare

Seagate ST43401N/ND Technical Information Seite 103