Chapter 13: Finding Slow Running Queries

Adaptive Server version 15.0.2 introduces ways to collect diagnostic information about slow running queries.

Adaptive Server includes the show_sqltext, tracefile, and export_options parameters for the set command parameters that enable you to collect diagnostic information about poorly-running queries without having to previously enable showplan or other investigatory parameters.