Archive for the ‘Storage: SAN & SSD’ Category

SQL under the hood (Part 1): Monitoring Current- & Pending Disk IOs (2010-3-10)

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 […]

How to increase SQL Database Full Backup speed using compression and Solid State Disks (2010-1-15)

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 […]

Better Tag Cloud