SHOW DISTRIBUTED_PLANCACHE STATUS

Note

This is a Preview feature.

The SHOW DISTRIBUTED_PLANCACHE STATUS command provides information about the status and performance of the Distributed Plancache.

This command provides statistics for the node on which it is run.

The following table describes the metrics returned by the SHOW DISTRIBUTED_PLANCACHE STATUS command.

Metric(s)

Description

Successful Downloads Since Startup 

Skipped Downloads Since Startup 

Failed Downloads Since Startup

The number of successful, skipped, and failed plan downloads from the DPC to the local PPC since startup.

Plans Uploaded Since Startup

The number of plans uploaded from the local PPC to the DPC since the startup.

Plans Deleted Since Startup

The number of plans the node has deleted from the DPC since startup.

DB Synchronizations Since Startup

The number of synchronization tasks (manual or automated) that this node has performed since startup.

Successful Downloads From Periodic Sync Since Startup 

Skipped Downloads From Periodic Sync Since Startup 

Failed Downloads From Periodic Sync Since Startup

The number of successful, skipped, and failed downloads that occurred during the periodic aggregator synchronizations since startup.

Applicable to aggregator nodes only.

Periodic Query Plan Syncs Since Startup

The number of periodic aggregator synchronizations since startup.

Applicable to aggregator nodes only.

Distributed Plancache Plans Used Since Startup

The number of plans loaded into memory from the PPC, which originated from the DPC. Tracks how effective the DPC has been in saving re-compilations.

Currently Queued Populate Download Tasks

Currently Queued Download Tasks

Currently Queued Upload Tasks

Currently Queued Delete Tasks

These metrics indicate the number of tasks queued in the DPC task queue.

Avg Plan Download Latency (ms) 

Avg Plan Upload Latency (ms) 

Avg Plan Delete Latency (ms)

The average latency (in milliseconds) from cloud storage.

Avg Duration For DB Plan Synchronization (ms)

Indicates the average length of a synchronization task.

Sample output of the SHOW DISTRIBUTED_PLANCACHE STATUS command:

SHOW DISTRIBUTED_PLANCACHE STATUS;
+-------------------------------------------------------+-------+
| Stat                                                  | Value |
+-------------------------------------------------------+-------+
| Successful Downloads Since Startup                    |  2341 |
| Skipped Downloads Since Startup                       |    45 |
| Failed Downloads Since Startup                        |    12 |
| Plans Uploaded Since Startup                          |   112 |
| Plans Deleted Since Startup                           |    65 |
| DB Synchronizations Since Startup                     |     7 |
| Successful Downloads From Periodic Sync Since Startup |    12 |
| Skipped Downloads From Periodic Sync Since Startup    |   107 |
| Failed Downloads From Periodic Sync Since Startup     |     0 |
| Periodic Query Plan Syncs Since Startup               |     1 |
| Distributed Plancache Plans Used Since Startup        |    90 |
| Currently Queued Populate Download Tasks              |     2 |
| Currently Queued Download Tasks                       |     6 |
| Currently Queued Upload Tasks                         |    33 |
| Currently Queued Delete Tasks                         |    23 |
| Avg Plan Download Latency (ms)                        |    55 |
| Avg Plan Upload Latency (ms)                          |    33 |
| Avg Plan Delete Latency (ms)                          |    43 |
| Avg Duration For DB Plan Synchronization (ms)         | 11231 |
+-------------------------------------------------------+-------+

Last modified:

Was this article helpful?