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

Migrating to Sybase Adaptive Server Enterprise 11.5 7-13

Adaptive Server Enterprise 11.5 Test Cycle: Testing for Performance

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 SQL Server 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 untimed and timed benchmarks.

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 pre-upgrade state

• Bottlenecks

• Other problems or mistakes

Be sure that you have enough default data cache after the upgrade.

Tune as needed to ﬁx problems. Between runs, restore your

databases from backup or perform a quick reset.

Refer to the Performance and Tuning Guide for more information. See

also Technical Information Library for the latest TechNotes and

White papers on issues that may affect performance.

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.

Tune as necessary to achieve your performance criteria.

Run tests as often as necessary to ﬁx problems and be able to

reproduce the ﬁnal results.

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

Keine Kommentare

Seagate ST43401N/ND Technical Information Seite 113