Archive for January, 2012

SQL under the hood (Part 2): Estimate the SQL Disk IO Workload based on the Virtual File Stats DMV. (2012-1-20)

Do you know how much data is being written and read on a daily basis by your SQL Server databases? SQL Server keeps track of these stats for you already; you just have to retrieve and interpret them correctly so you can turn this data into valuable information. A couple of years ago I was [...]

Better Tag Cloud