Celebrating Life: The Princess Pumpkin Puss, A Pain In My Neck, Randy Pausch, & Lt. Col. Frank Slade Teach Us About Living Life

This is nominally a personal productivity as well as a SQL Server performance blog, but I seldom indulge that facet—too busy being productive, don’t you know? Ward Pond‘s annual amalgam (May Glad Tidings be Upon You) inspired me to do something similar.  My plans changed Sunday & instead I am writing to celebrate life. Princess…

8

SQL Server Schema Best Practices from the SQL Server Customer Advisory Team (SQL CAT)

An authoritative reference on schema usage in SQL Server 2005 is now available. Along with my buddy Joe Sack, it’s been my privilege in the last few months to serve as Technical Reviewer on white papers for the SQL Server Customer Advisory Team (SQL CAT). The latest-&-greatest has been released: SQL Server Best Practices –…

1

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)

The purpose of this post is to document Disk Partition Alignment Essentials. It is intended for engineers who are already familiar with disk partition alignment yet want a “cheat sheet”.   As most of you know, partition alignment is an essential best practice. We are seeing I/O enhancements in the lab & at important real-life…

12

Case Study: Part 2: CXPACKET Wait Stats & ‘max degree of parallelism’ Option: Suppressing Query Parallelism Eliminated CXPACKET Waits & Liberated 30% of CPU

Introduction This is the second of a four-part series: Introduction to Query Parallelism Parallelism Suppression: Analysis, Remediation, & Results (this post) Parallel Query Identification & Remediation Summary Executive Summary In my first post in this series, I documented introductory information related to query parallelism in SQL Server. Be clear!  This series is not an indictment…

7

Case Study: Part 1: CXPACKET Wait Stats & ‘max degree of parallelism’ Option: Introduction to Using Wait Stats to Identify & Remediate Query Parallelism Bottlenecks

This is the first of a four-part series: Introduction to Query Parallelism (this post) Flipping the Bit Expensive Query Identification & Remediation Summary Query Parallelism The SQL Server configuration option max degree of parallelism determines the maximum number of processors which can participate in query execution.  The default value is 0, allowing SQL Server to…

3

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 3: PASS 2008

I’ve spoken publicly several times this year to crowds large-&-small: TechReady 6 (an internal Microsoft conference) Indy Tech Fest ITT Commencement Last week was my first external international conference, the Professional Association for SQL Server 2008 Community Summit. This is my second summit & first speaking opportunity. The PASS summit is an incredible event. Plan…

5

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

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