Index

D  E  M  R  S  U  W 

D

Database Replay
about, 1.1
methodology, 2
reporting, 2.4
usage, 1.1
using, 2
workflow, 2
workload capture, 2.1, 3
workload preprocessing, 2.2
workload replay, 2.3
database version
production system, 12.1, 12.2
system running SQL Performance Analyzer, 12.1, 12.2
test system, 12.1, 12.2

E

EXECUTE_ANALYSIS_TASK procedure, 12.1.4.2, 12.1.5.2, 12.2.1.2, 12.2.2.2

M

mapping table
about, 12.1.2
creating, 12.1, 12.1.2
moving, 12.1, 12.1.2

R

regressed SQL
tuning, 11.1.3, 11.2.3, 12.1, 12.2

S

SELECT_SQL_TRACE function
parameters, 12.1.3
syntax, 12.1.3
using, 12.1.3
SQL performance
comparing, 12.1, 12.2
SQL Performance Analyzer
about, 1.2
comparing SQL performance, 11.2.1
creating a task, 8.2
executing the SQL workload, 9.2
executing the SQL workload after a change, 10.2
following guided workflow, 8.1.2, 8.1.2
initial environment
establishing, 9
input source, 12.1
making a change, 10
methodology, 7
monitoring, 11.2.4
performance data
collecting post-change version, 10
collecting pre-change version, 9
comparing, 11
remote test execution, 12.1.5, 12.2.1, 12.2.2
setting up the test system, 7.2
SQL Performance Analyzer report
general information, 11.1.2.1, 11.2.2.1
global statistics, 11.1.2.2
global statistics details, 11.1.2.3
result details, 11.2.2.3
result summary, 11.2.2.2
reviewing, 11.1.2, 11.2.2
SQL tuning set
selecting, 7.3, 8
SQL workload
capturing, 7.1
executing, 7.4
transporting, 7.2
system change
making, 10
task
creating, 12.1, 12.2
testing parameter change, 8.1.1
usage, 1.2
using, 7
workflow, 7
SQL statements
regressed, 1.2
SQL Trace
about, 12.1.1
enabling, 12.1, 12.1.1
trace level, 12.1.1
SQL trace files
about, 12.1.1
moving, 12.1, 12.1.1
SQL trial
about, 7.3, 7.4
building
post-upgrade version, 12.1, 12.1.5, 12.1.5.1, 12.2, 12.2.2
pre-upgrade version, 12.1, 12.1.4.1, 12.1.4.2, 12.2, 12.2.1, 12.2.1.1, 12.2.1.2
SQL tuning set
about, 7.1
building, 12.1.3
constructing, 12.1
converting, 12.1, 12.1.4, 12.1.4.1, 12.2.1.1
using APIs, 12.1.4.2

U

upgrade environment, 12.1, 12.2

W

workload capture
about, 2.1
capture directory, 3.2.3
capture files, 2.1
options, 3.2
prerequisites, 3.1
restarting the database, 3.2.1
restrictions, 3.3
workload filters, 3.2.2
workload filters
about, 3.2.2
exclusion filters, 3.2.2
inclusion filters, 3.2.2
workload preprocessing
about, 2.2
replay files, 2.2
workload replay
about, 2.3
replay client, 2.3