
CHAPTER 7 Test: Ensuring Stability and Performance
91
Test System Upgrade
Perform the upgrade on the test system following the instructions in the
installation guide. 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 Database
Administration Changes”. However, do not change your Adaptive Server
configuration to use new features at this time.
Note Your first 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
dbccs 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.
Post-Upgrade Single-User Tests
In single-user tests, verify that:
• The optimizer is creating the same or better query plans. Differences in
query plan may be due to optimizer changes, depending on the ASE
version you were running. Determine whether you need to change
application code to compensate. See Chapter 7, “Test: Ensuring Stability
and Performance”, for possible optimizer issues.
• I/O counts, physical and logical, are the same as they were before the
upgrade.
Post-Upgrade Multi-User Tests
After reloading backups to return the test system to a known state, run the
following benchmarks.
• Untimed Benchmarks
• Timed Benchmarks
Komentáře k této Příručce