Hello, I am Henry and I want to share my insight about your concern.
Based on the scenario you've described, here is my analysis and recommendation. I see that the primary risk is not storage space, but severe storage I/O performance degradation. When a checkpoint is deleted, the merge process is extremely I/O-intensive and can dramatically slow down all other VMs sharing that same storage (CSV).
- Is a frequent snapshot strategy safe and supported?
- Not recommended or supported for critical production applications, especially SQL Server.
- Reason: Hyper-V checkpoints (relying on .avhdx files) create layers of virtual disks. This leads to a significant degradation in I/O performance, particularly as the snapshot chain grows.
- The merge operation, which occurs when a checkpoint is deleted, is also resource-intensive and impacts VM performance.
- Have others used this successfully?
- Yes, but typically in development, testing, or non-critical workloads where the need for a quick rollback outweighs performance concerns.
- What risks should I be aware of?
- Failover Behavior: A complex snapshot chain can complicate failover. A corrupted checkpoint file could lead to a failed failover and potential downtime.
- Cluster Integrity: The constant creation and deletion of checkpoints place a high strain on the I/O of the Cluster Shared Volume (CSV) and cluster management services, which could lead to instability.
- Data Loss/Corruption: Rolling back to a snapshot means losing all data changes since that point, which can cause data integrity issues for transactional applications like SQL Server.
Final Advice:
- Use Checkpoints sparingly: Reserve checkpoints for specific, short-term, controlled scenarios, such as before applying a major patch. Always delete the checkpoint as soon as the change is validated.
- Thoroughly test: If you decide to proceed with this strategy, you must test it rigorously in a non-production environment with an identical workload to understand its real-world impact before deploying it in production.
I hope this information is helpful.