Disk Partition Alignment: It Still Matters--DPA for Windows Server 2012, SQL Server 2012, and SQL Server 2014

Introduction I continue to receive dozens of inquiries each year about this issue.  The “fix” in contemporary versions of Windows Server combined with the absence of formal guidance since the white paper’s publication has led some to believe that disk partition is no longer a best practice.  This is incorrect.  Partition alignment remains a best…

0

Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not the Entire 2.5GB Windows 7 SDK: Part 1

Say It Ain’t So! In my first post on Xperf, I described the simple 4.4MB download necessary to install the Windows Performance Analyzer (WPA) & the other tools which comprise the Windows Performance Toolkit (WPT), including Xperf. I was surprised to learn that the toolkit is no longer available in a discrete download. The only…

1

A Rendezvous With Destiny: PASS 2009 (#sqlpass)

Rendezvous With Destiny Forty-five years ago, Ronald Reagan aka Ronaldus Magnus spoke to Americans of our rendezvous with destiny. In a few short days the SQL Community will rendezvous in Seattle for the PASS 2009 Summit. This time last year, eager & anxious, I was preparing for my very first presentation at PASS.  Those who…

2

SQLIOSim Parser by Jens Suessmeyer & Yours Truly

New! Improved! v.3.3.0 Now Available on CodePlex!  Preamble SQLIOSim Parser shreds the results of SQLIOSim.log.xml in seconds, allowing easier & more accurate interpretation of the output of SQLIOSim. SQLIOSim is a tool written by CSS Engineer Bob Dorr.  Many of you know Bob from the excellent insights he shares on the CSS SQL Server Engineers blog. …

4

Aspiring Geek Speaks This Week Yet Again: Perpetual Technologies (PTI) Back-to-School with Microsoft and Oracle Event

Yesterday I flew to Minneapolis to speak at PASS MN on disk partition alignment.  I left for the airport immediately afterward to get home to Indianapolis in order to speak at Perpetual Technologies, Inc. (PTI) 2nd Annual Back to School with Microsoft & Oracle Event. PTI is home to some great folks, including my friends…

0

xPerf: Once I Was Blind and Now I See

I’ve been aware of the buzz around xPerf for quite some time.  I flagged emails from Microsoft Premier Field Engineers Clint Huffman (author of PAL) & Shane Creamer (author of Vital Signs) who in internal DLs both cited the tool way back in 2008. Robert Smith is also a Microsoft PFE.  He is one of…

4

sys.dm_db_index_operational_stats: Kick Your Assumptions: Part 1

                  A two-part tale in which your humble correspondent interrogates                    databases & Very Smart Persons (VSPs), & is forced to kick his ass-                   umptions regarding a popular DMF. Executive Summary Documentation for the DMF sys.dm_db_index_operational_stats in BOL here & here as well as elsewhere is incorrect.  In fact, ops stats will not return…

0

Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars

I recently collaborated with Microsoft PFE Daniel Janik to create a template to make the case for disk partition alignment.  Perhaps your customers or stakeholders within your organization can benefit.  This work was recently broadcast throughout PFE DLs as well as the April 2009 SQLRAP Newsletter.  Thanks also to Cindy Gross & Ward Pond for…

11

A Language for Software Architecture by JD Meier in The Architecture Journal

J.D. Meier is a Principal Program Manager for Microsoft’s Patterns & Practices team.  He’s a great writer & a clear thinker.  J.D.’s Sources of Insight is devoted to getting results & balancing life. His latest-&-greatest publication is available now: A Language for Software Architecture J.D. Meier, The Architecture Journal, #19, TechEd 2009 Special Edition Article…

0