Category Archives: Performance

Disk allocation unit size

How to determine what allocation unit size was selected when a disk was formatted? If a disk was formatted incorrectly i.e. a SQL Server data volume,  but you want to check what allocation unit size was selected  when the disk … Continue reading

Posted in Performance, Tips | Comments Off on Disk allocation unit size

Scaling MDW

SQL Server 2008 introduced the MDW – a Management Data Warehouse. The MDW is a data warehouse for storing performance data about your SQL servers. It is best configured using a centrally located database – in the environment I work … Continue reading

Posted in Performance | Comments Off on Scaling MDW

Capturing Timeouts

The only way to capture timeouts is via SQL Trace – you need to know what was running/executing at the time of the timeout and SQL Trace is the tool to capture this. Do not confuse SQL Trace with SQL … Continue reading

Posted in Performance | Comments Off on Capturing Timeouts