Modern Database Management: Chapter 11 Review Question 28

explain-the-purpose-of-heartbeat-queries


Question

Explain the purpose of heartbeat queries.

Answer

The Heartbeat query is a query that is used to test the performance of the database, and to predict the response time of the database, the database administrator posts a query. This query is also called canary queries. Heartbeat queries can take a different amount of time to process in the database. This depends on the workload.


Purpose:

Heartbeat queries are straightforward queries that can run various times throughout the day or night to privilege the RDBMS's performance by the DBA (Database Administrator).

If the query takes a long time to run, there might be a source problem, say an unsuitable combination of jobs or inefficient queries.


إرسال تعليق

Post a Comment (0)

أحدث أقدم