Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

TSQL Tue 64: Calling All Tuners and Gear Heads

T-SQL TuesdayIt is month 64 of Adam Machanic’s monthly blog party known as TSQL Tuesday.  I’m very honored to be hosting this month.  Let’s get to it.  This is your official invite to the SQL Server Performance Grand National.  I want posts tackling “focused” performance tuning.

By “focused” I mean tackle something head on; the more secret sauce, tricks, code samples, operator costs, or demonstrable metrics against a defined problem the better.  This month is for the gear heads.  Don’t wimp out by avoiding hints, plans, or guides.  General practice is for wusses.  Write something that’ll either go BIG or flame out half-way down the track.  Drag racers aren’t grocery getters.  If your post begins with the phrase… should be implemented with caution – you’re doing it right.  If you’re an SSIS, SSDT, SSRS person – we’ve got a funny car division for you too.  Tell us edge cases where you’ve make your stuff scream.

8367209091_0638971788_z

Need some ideas?

  • Tackle a non set based problem you’ve improved in the wild
  • Discuss hardware settings or IO – anyone using a flash array?
  • Got a solution to a niche wait type?
  • Tackle indexing edges (good or bad)
  • Columnstore !!!
  • Hash buckets !!!
  • Parallelism !!!
  • Break down and improve a peculiar query plan operator

operators

Remember the rules?  Your post must go live on Tuesday March 10th between 00:01 and 23:59 hours.  Once you’re post has gone up, drop a comment with a link on this page back to your post.  Finally, your post should contain the original TSQL Tuesday logo above and it should link back to here.

Ok, got your launch control settings ready?  I’m looking for engine noise that’ll scare children.  I want code blocks that’ll do a quarter mile in under nine seconds.  I want the irresistible smell of top fuel, rubber, nitrous, and IOPS in the air.

GO!!

Image credits: Super Charger used under Creative Commons – https://www.flickr.com/photos/k-ribou/8367209091

10 comments on “TSQL Tue 64: Calling All Tuners and Gear Heads

  1. Rob Farley
    March 9, 2015

    Mine’s at http://sqlblog.com/blogs/rob_farley/archive/2015/03/10/tuning-parallel-data-warehouse-queries.aspx

    No query plan diagrams for me this time… Rare, I know…

    Thanks for hosting, Russ.

    • Russ Thomas ( @SQLJudo )
      March 10, 2015

      Gotta admit – I was looking forward to some diagrams. PDW puts you squarely in the funny car division however – so it’s all good.

  2. Russ Thomas ( @SQLJudo )
    March 10, 2015

    My own submission is here. Tuning SSIS with In-Memory OLTP http://wp.me/p2TlyL-wv

    • Russ Thomas ( @SQLJudo )
      March 10, 2015

      It may not have hints or guides; but it has triggers – so I think we’re pretty much even. Nice post.

  3. timothydpeters
    March 10, 2015
  4. Pingback: T-SQL Tuesday Topics | Voice of the DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Information

This entry was posted on March 2, 2015 by in Performance, T-Sql Tuesday.
%d bloggers like this: