# Data Views for the DDB Partition Details Report

This report offers the following views.

## Average Q&I Trending

The Average Q&I Trending chart displays the trend of average query and insert (Q&I) time for deduplication database partitions.

This chart helps you:

- Identify partitions with slower performance
- Compare performance across partitions
- Detect performance degradation over time

### What the chart shows

- X-axis: Date (last 3 months)
- Y-axis: Average Q&I time (microseconds)

The chart groups data by partition name and displays up to 10 partitions at a time.
If more than 10 partitions match the selected filters, the chart displays the top 10 partitions based on Q&I time.

## Growth Trending

The Growth Trending chart shows how records grow over time for each partition.

This chart helps you:

- Understand partition-level growth patterns
- Identify buildup of records pending deletion
- Determine whether pruning or space reclamation is required

### What the chart shows

- X-axis: Date (last 3 months)
- Y-axis: Record count

### Metrics tracked

- Primary Records – Active records stored in the partition
- Secondary Records – Additional records stored in the partition
- Records to Be Deleted – Records with zero reference count pending cleanup

A steady increase in records pending deletion may indicate delayed pruning activity for the partition.

## Partition Details

The Partition Details table is the main section of the report and provides detailed information for each deduplication database partition.

### Understanding the Table Data

Column | Description
--- | ---
Partition Name | Displays the partition name along with the partition ID.
MediaAgent | Shows the MediaAgent that hosts the deduplication database partition.
Deduplication DB Path | Displays the file system path where the partition is stored.
Status | Indicates the current operational state of the partition. • Ready – Normal operation • Sealed – Partition is sealed and read-only • Other values may indicate transitional or error conditions
Avg Q&I Time (μs) | Shows the average query and insert time for the partition, measured in microseconds. Higher values may indicate performance issues.
Primary Record Count | Total number of primary records stored in the partition.
Secondary Record Count | Total number of secondary records stored in the partition.
Size of Partition | Total disk space consumed by the partition, displayed in MB, GB, or TB.
Free Space | Available free space on the partition path, displayed in MB, GB, or TB.
Last Backup Time | Timestamp of the most recent backup operation that used this partition.
Last Backup Job ID | Job ID associated with the most recent backup operation for the partition.

×

Loading...