Archive for the ‘Workload & Capacity Planning’ Category

Introduction to SQL Server 2012 Parallel Data Warehouse (2013-12-25)

Surprisingly how we over the years have accepted that we need to invest a lot of time and energy to move data from ‘A’ to ‘B’  and to maintain a well performing data warehouse platform where your reports & queries respond within a reasonable amount of time (and I’m not referring to just SQL Server […]

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