White Papers

BP1014 Enhancing SQL Server Protection using Dell EqualLogic Snapshot Smart Copies
15
Figure 7 – System and database performance impact when creating SQL Server snapshot
In the next section, we now look at how snapshots at EqualLogic SAN layer perform under similar test
conditions.
3.4 Testing EqualLogic Smart Copies
EqualLogic Auto-Snapshot Manager/Microsoft® Edition (ASM/ME) gives a SQL Database administrator
the ability to create a “Smart Copy Snapshot” of the database. A “Smart Copy Snapshot” is a
transactionally consistent point in time copy of the SQL Server® database. Please see Appendix A for
more details about EqualLogic Auto-Snapshot Manager/ Microsoft® Edition.
In this section we present the results of the following system tests:
A. Time to create an EqualLogic “Smart Copy” snapshot of a SQL Server® database
B. System impact during Smart Copy creation