Chapter 9Capturing Query Processing Metrics

New to ASE 15, Sybase introduces a mechanism to capture many existing query metrics, in addition to some new metrics. In this chapter, we explore how to capture and analyze the Query Processing Metrics (QP Metrics). The chapter explores how to capture QP Metrics as well as how to query the QP Metrics view. We discuss how to analyze the query metrics data in order to detect the most frequently executed queries and the most expensive queries, and how to monitor the performance of the same query over time. Suggestions are also made on how to make performance degradations a little more obvious when using the QP Metrics capture.

Alternatives to Query Processing Metrics

Before going further into the topic ...

Get The Official New Features Guide to Sybase ASE 15 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.