New whitepaper on database snapshots

Well, it was released a year ago but I only just found out about it last week. The SQL CAT team published a whitepaper last year called Database Snapshot Performance Considerations under I/O-Intensive Workloads. For a variety of workloads and with different numbers of concurrent database snapshots, it covers:

How much time does it take to create a database snapshot?
Transaction and I/O patterns during database snapshot creation
Transaction throughput and response time with multiple database snapshots
Impact of database snapshot on index creation
Restoring the source database from a database snapshot
Recommendations

Check it out at http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBSnapshotPerf.docx

Posted Under:

Database Snapshots, Whitepapers

Leave a Reply Cancel reply

Other articles

AI Stories and Thoughts

iAI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic

Reflections on 15 Years

(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to

Presenting a workshop at PASS Summit West in Seattle!

I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and

Summer Sale: $699 Blackbelt Bundle!

Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQL Server Jumpstart+ Bundle $4,070.00 Original price

The SQL Server Transaction Log, Part 4: Log Records

(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the

SQL101: Application data consistency checking

It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.