Link to home
Create AccountLog in
Avatar of First Last
First LastFlag for United States of America

asked on

VMware ESXi 5 - Large Snapshot for SQL server Standard 2008 R2 with CBT enabled on Veeam

HI -

I'm using Veeam to backup our servers. All the servers backup very fast even the problem server SQL. The backup of SQL Server 2008 Standard Edition takes less than 15 minutes and is about 5GB in size. The snapshot created for the C drive (Server 2008 R2 OS) and the D drive (SQL databases) is roughly 400MB each. Why does it take an estimated 90 minutes to remove my snapshots and what can you recommend to esure the snapshots are removed faster?

I do see through vmware my disk read and write reach for the sql server is steady around 18,000 KBps.

On all my other servers the snapshots remove much faster. Sometimes the snapshots are even in gigabytes and take just minutes!

I have the SQL server on a LUN with 15K disks.

Thank you for your input
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

faster disks and Hypervisor host processors will allow, quicker removal of snapshots.

have you considered completing the backup during a "quiet period" for your servers.

Veeam have recently stated, that slow disk subsystems are not suitable for snapshot based backups.
ASKER CERTIFIED SOLUTION
Avatar of caronas
caronas

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account