Download View this document as PDF

Contents
Environment and system requirements...................................
Starting the QPTune GUI ........................................................
Fixing missing statistics...........................................................
Tuning Task.............................................................................
QPTune reference information .......................................................
CHAPTER 3
45
46
46
47
50
Running the Query Processor in Compatibility Mode ............... 55
Enabling compatibility mode .......................................................... 55
Feature support in compatibility mode ........................................... 56
Additional trace flag for diagnostics ............................................... 58
New stored procedure sp_compatmode ........................................ 58
Changes to @@qpmode global variable ....................................... 59
Diagnostic tool................................................................................ 60
Index ............................................................................................................................................. 61
iv
Adaptive Server Enterprise