Seagate ST43401N/ND Informacje Techniczne Pobierz pdf (Strona 111)

Migrating to Sybase Adaptive Server Enterprise 11.5 7-11

Adaptive Server Enterprise 11.5 Test Cycle: Testing for Performance

• Post-Upgrade Multi-User Tests 7-13

➤

Note

Benchmarks test server processing speed. Therefore, run your

benchmarks from a light-weight client so that all processing happens at the

back-end.

Pre-Upgrade Single-User Tests

After you create the test system at the same SQL Server level as the

production system and before running benchmarks, you need to

sync the test system with the production system so that comparisons

to the new server are valid.

Optimizer

Compare

showplan and output from dbcc 310 and 302 which you

gathered in Chapter 2, “Analyze: Documenting Business

Requirements”, to that of the test system to verify that the optimizer

is making the same decisions. Some possible causes of optimizer

differences include:

• Data and data distribution problems. Check data layout and be

sure that these match the productions system.

• Index deﬁnitions. Verify that your reindexing scripts worked.

Using sp_helpindex, compare the index deﬁnitions of the

production and test systems.

Resolve any problems before going on.

I/O

Verify that the test server is performing the same amount of I/O.

Physical and logical I/O should be in the same proportion as in the

production system. Use

statistics io output to compare.

Pre-Upgrade Multi-User Tests

When the optimizer is behaving the same as it did in the production

system, you are ready to run benchmarks.

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

Brak uwag

Seagate ST43401N/ND Informacje Techniczne Strona 111