[WEBINAR] Application Acceleration: Faster Performance for End Users

SQL Query Monitoring

Definition - What does SQL Query Monitoring mean?

SQL query monitoring is the process of monitoring the performance and output of SQL queries. A SQL query can be simple or complex, but it is defined with a definite purpose, for example, retrieving the details of all cars sold last year. The main purpose of SQL query monitoring is to determine if the query is able to fulfill the purpose within the expected time and whether it is able to provide the required output. Monitoring is also used for identifying performance improvement measures.

Techopedia explains SQL Query Monitoring

SQL queries, depending on their intended functions, can be highly complex with multiple nested queries, branches or loops. Such queries, if not designed well, can cause problems such as slow retrieval, performance drop and high CPU and memory usage. SQL query plans need to be well-written and designed to optimally use system resources. SQL query monitoring tasks need to identify all such queries that have been problematic and high consumers of system resources. If need be, such queries can be reviewed for unnecessary nested queries and such nested queries may be removed or optimized, as is necessary. Companies tend to use web-based consoles for SQL query monitoring as such consoles providing analytics on the health and performance of all SQL queries that are running at a given point of time.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.