🔍 Factors & Their Impact on Backup Performance:
Least Used Tables (via last accessed)
➤ Helps identify cold data that can be excluded from frequent backups or moved to separate subclients for infrequent backup schedules.
➤ Reduces backup size and time.
Tables with LOBs (Large Objects)
➤ LOBs, especially non-secure and uncompressed, significantly increase backup time.
➤ Enables prioritization of SecureFiles or compression strategies for LOBs to improve performance.
Tables with Partitions Recently Modified
➤ Allows targeted incremental or subclient backups focusing only on recently changed partitions.
➤ Reduces unnecessary scanning and data movement.
Fragmentation Details
➤ Identifies bloated tables or indexes causing excessive I/O during backups.
➤ Supports reorg planning to optimize space usage and backup efficiency.
Partitions with Compression Enabled/Not
➤ Compressed partitions result in less data to read and transfer, enhancing backup speed.
➤ Highlights areas where enabling compression can yield performance gains.
---
✅ Use Case: Backup Strategy Tuning
Use the above insights to:
Define custom backup policies (e.g., frequent for hot data, rare for cold).
Improve subclient segmentation.
Apply compression, LOB optimization, or reorganization where it matters most.
0 comments:
Post a Comment