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

PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server

I’m frequently asked questions about which PerfMon counters to use & what thresholds to rely on.  I’ve been amalgamating this information for years in the form of an Excel workbook:  PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls.   The current incarnation of this workbook includes worksheets related to the following topics: ·         Performance objects for SQL Server 2000, 2005, & 2008…

13

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck

<Note: 20081119:  Deck updated w/ new graphics, perf metrics, & dynamic disk info>  <Note: 20090225:  Deck updated & moved to skydrive> <Note: See also Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)>   Now that SQL Server wait stats are formally documented & DMVs are available, disk partition alignment may…

18