AdventureWorks 2014 Sample Databases Are Now Available

  Where in the World is AdventureWorks? Recently, SQL Community feedback from twitter prompted me to look in vain for SQL Server 2014 versions of the AdventureWorks sample databases we’ve all grown to know & love. I searched Codeplex, then used the bing & even the google in an effort to locate them, yet all…

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

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

Wait Stats by Joe Sack

Wait stats rock.  As I shared recently with friends, when it comes to SQL Server performance, wait stats are the #1 arrow in my quiver, the first tool out of my toolbox, the Vera of guns (see the Firefly episode Our Mrs. Reynolds to divine that reference). In a previous post I stated the importance…

2

Analyzing Storage Performance by Robert Smith on the Counter-of-the-Week (COTW) Blog

In my role with MS IT’s Assessment, Consulting, & Engineering (A.C.E.) team, I work with some of the best application perf engineers in the world.  However, A.C.E. doesn’t have a monopoly on talent; there are some great engineers throughout Microsoft. One such geek is Robert Smith who has just published a great new post on Clint Huffman’s Counter…

0

VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)

My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally. Now it’s time to spread my wings a bit & learn about Visual Studio Team System (VSTS) web testing.  Spread Your Wings! https://www.youtube.com/watch?v=JtsJDTyY95g My colleague & A.C.E. performance engineer Chris Lundquist has compiled a 6:58 wmv featuring his unscripted…

1

SSMS Query Results: “Include column headers when copying or saving the results"

In my work with external customers, I collaborate with some excellent DBAs & Architects.  But I’ve noticed many of them are not aware that you can capture column headers from query results to grid in SSMS. When a very bright engineer I work with—not a SQL SME yet one of the smartest guys I know—told me…

8

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 2: Adding HP EVA 8000 to Veritas Enterprise Administrator “Track Alignment Settings” Dialog

  Background In a previous post I documented the importance of disk partition alignment as a foundation for optimal disk I/O performance.  In the lab & in the field we’ve commonly found performance enhancements of 30% – 40% by a variety of metrics.    Though Windows Server 2008 provides for out-of-the-box alignment for new partitions,…

4

Drum Roll, Please…The Debut of The SQL DMV All-Stars Dream Team!

<#Author’s note: Though I originally posted this six years ago, it’s still one of my most popular posts.  I still use the queries & I’ve updated them a bit.  Enjoy!Jimmy May2015-01-14#> The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provides us with all manner of wonderful information, much of which was heretofore…

9

Is Twitter the YouTube of 2008?

Always in pursuit of the elusive creature known as Work/Life Balance, I discard activities which monopolize my scarce bandwidth.  I even struggled with tagging this post under “Productivity”.  Yet it struck me that Twitter was reaching critical mass, so I thought I ought to see what all the buzz was about.  With a shortcut on…

3