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

7-12 Test: Ensuring Stability and Performance

Test Cycle: Testing for Performance Adaptive Server Enterprise 11.5

Untimed Benchmarks

In multi-user mode, run untimed benchmarks as often as necessary,

capturing response time and throughput metrics. Resolve:

• Differences, such as cache hit rate, to the production system

• Bottlenecks caused by saturated devices

• Other problems or mistakes

Between runs, restore your databases from backup or perform a

quick reset.

Timed Benchmarks

Always restore your databases from backup so they are in a known

state when running timed benchmarks. Gather response time and

throughput metrics. Run as often as necessary to ﬁx problems and be

able to reproduce the ﬁnal results.

Test System Upgrade

Perform the upgrade on the test system following the instructions in

the installation guide, Installing Sybase Products. Be sure to perform

all steps so that the test upgrade is a walkthrough of the real

upgrade. Make the memory and disk space changes you determined

that you needed in Chapter 6, “Implement: Making Required

Database Administration Changes”. However, do not change your

Adaptive Server conﬁguration to use new features at this time.

➤

Note

Your ﬁrst objective after upgrade is to test Adaptive Server’s out-of-the-box

performance. Wait until later to try new performance tuning features.

Resolve all problems and note them for reference. The installation

guide gives detailed troubleshooting information.

After the upgrade:

• Perform

dbcc’s on all databases.

• Back up all databases, including master and sybsystemprocs. You

will need backups to restore the test system to a known state

between timed benchmarks.

1 2 ... 107 108 109 110 111 112 113 114 115 116 117 ... 171 172

Sem comentários

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