I have blogged before regarding how to Identify Application vs Network Performance Issues using SQL Server Dynamic Management Views (DMV).
Fast Track Data Warehouse Reference Guide for SQL Server – SQLAuthority News
The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Server data processing.
SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions
While helping a friend, I found the Technical Reference Guides for Designing Mission-Critical Solutions, an interactive map of architecture guidance.
SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide
The Fast Track Data Warehouse 3.0 reference guide is out. It gives a method and real examples for balancing hardware and database setup for data warehouse loads.
SQL SERVER – IO_COMPLETION – Wait Type – Day 10 of 28
IO_COMPLETION means tasks are waiting for non-data page I/O to finish. Day 10 explains this wait type and what to check in your IO subsystem.
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
Reducing CXPACKET wait stats on a high transactional database: what CXPACKET means, and when lowering the degree of parallelism really helps.
SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements
A Microsoft white paper on SQL Server 2008 Full-Text Search internals and enhancements, including the new Full-Text Engine built into the database.