What is the difference between Avamar and Data Domain deduplication?
Use the backup job data to compare how many duplicate chunks each system removed and how much storage each one saved. Return only jobs with a non-null deduplication result.
job_name, dedup_system, total_chunks, duplicate_chunks, dedupe_ratio, storage_saved_gbdedupe_ratio is NULLjob_name, then dedup_system| Column | Type | Description |
|---|---|---|
| job_idPK | INT | Unique backup job identifier |
| job_name | VARCHAR(100) | Backup job name |
| total_chunks | INT | Total chunks processed by the job |
| chunk_size_mb | NUMERIC(10,2) | Average chunk size in megabytes |
| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique metric row identifier |
| job_id | INT | References backup_jobs.job_id |
| dedup_system | VARCHAR(50) | Deduplication system name, such as Avamar or Data Domain |
| duplicate_chunks | INT | Number of duplicate chunks detected |
| dedupe_ratio | NUMERIC(6,4) | Recorded deduplication ratio, may be null for incomplete runs |