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

Aspiring Geek Speaks This Week: PASS Minnesota

Greetings, my current colleague & former MVP Lara Rubbelke (blog | twitter) was gracious enough to invite me to speak this week at PASS Minnesota aka PASS MN. I’ll be reprising my spiel on Disk Partition Alignment, the Best Kept Secret in SQL Server I/O Performance.  For more details, see PASS MN’s September Meeting or…

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

SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al.

Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT team has just published a new whitepaper for which I had the opportunity to provide a technical review.  The author is SQL CAT best practices maven Sanjay Mishra.  Contributors include SQL CAT member Sunil Agarwal and architects Marcel van der…

1

Lured by Ward Pond, Chris Shaw’s Notorious SQL Quiz Ensnares Me In Its Web

SQL IT Operations Excellence IP Architect, colleague, & friend Ward Pond tagged me in a meme started by Chris Shaw (aka SQLShaw who originally tagged a whole lot of geeks including Thomas LaRock aka SQLRockster formerly SQLBatman (R.I.P.) & still lover of bacon who tagged Jeremiah Peschka aka peschkaj who tagged Michelle Ufford aka SQLFool who…

1