Before you begin to diagnose query problems, make sure you:
Installed the monitoring (MDA) tables and you have access to them.
Enabled query monitoring in both the Adaptive Server 12.5 and 15.0 systems
Have permission to run sp_configure, if needed.
Have permission to turn on set command options in the query processor to get the diagnostics output.
Are able to turn on trace flag 3604 and 3605
Plan for sufficient file space; some of the outputs can be very large and may overwhelm your current space configuration.
Practice capturing query plans using abstract query plans and practice running monitor tables to better understand how the tables work and how large you need to configure the pipes for statement, SQL text, and plan text.
Create a test database to use as a practice area. You may bulk-copy output from the old and new servers into this database to perform SQL analysis, so create your test database on the 15.0 server to facilitate data copying.
Plenty of free space (more than 2GB) for the system segment.
