Do you know how many disk IO’s are being processed by your SQL Servers at this very moment? And how many of them are pending, waiting to be serviced? Which databases are the top IO consumers and which queries are actually creating the majority of the IO load? In this blog I will focus on […]
Category:
Backup & Restore,
SQL 2008 R2,
Storage: SAN & SSD | Tags:
Backup,
Buffercount,
Compression,
DBCC TRACEON (3213,
DBCC TRACEON (3605,
Maxtransfersize,
Restore,
Solid State,
SQL2008R2 |
13 Comments
The SQL 2008 Database backup compression feature (which was introduced as a SQL2008 Enterprise Edition only feature) will become available in the SQL2008 R2 Standard Edition also ( SQL 2008 R2 Editions). I’m using the compression feature for quite some time now and really love it; it saves significant amounts of disk space and increases […]
