Query Plan Monitoring

What Does Query Plan Monitoring Mean?

Query plan monitoring is the act of monitoring the performance and output of a query during execution. A query plan provides clear, logical steps to perform tasks such as querying databases and retrieving data. Just like creating a query plan is a complex task, monitoring it for performance and output is a complex process. Monitoring is a multidimensional task and the plan needs to monitor multiple aspects of a query such as performance, nested steps and their performance, and speed of retrieval.

Advertisements

Query plan monitoring is also known as SQL plan monitoring.

Techopedia Explains Query Plan Monitoring

A query plan is a complex set of steps framed depending on what the goal of the query is. For example, a query retrieving the names of all employees in the finance
department of a small company would likely be a simpler query than one
that retrieves the names and passport numbers of employees whose names contain certain letters and who reside in certain states. Complex plans can have nested queries, loops or branches and each complexity may mean querying a different set of databases, data sources or tables in different locations.

While it is simple to monitor query plans on simple queries, it takes a detailed review of query plans on complex queries. For example, complex queries with much nesting and branching can be expensive and consume a lot of time and system resources. It is the job of the query plan to identify the specific query part which has been causing a drop in performance, and that can be a time-consuming task.

Advertisements

Related Terms

Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.