An oldie but goodie–SQL Performance Turning


While looking through past performance talks and presentations I came across this talk done at a BlackBoard.com conference and since it was already in the public domain I thought it worth sharing here.  Keep in mind while the tuning principles are timeless there are some cool new techniques around performance turning and monitoring in SQL 2008+ like Extended Events (XEvents ).  Helping to deliver XEvents was truly a fun time.

image

(click the image above to see the presentation deck)

Comments (1)

  1. TToni says:

    There's a very bad recommendation in that deck: Stripe size for RAIDS should not be lower than one extent (64 kb) since this is the most read an written unit in SQL Server I/O (in data files). Setting it lower will seriously degrade your general I/O performance. With lots of large read operations I would even recommend 256 kb to allow for more efficient read ahead.