Performance

SQL Query Processing

SQL Query Processing

How SQL Queries are processed by the Relational Engine. Parsing, Resolving, Optimizing, Compiling, and Executing to return SQL Sets.

Free SQL Performance Scripts

This is why I love Twitter to keep up with the #SQLFamily. A question was asked by Chrissy LeMaire about scripts that Microsoft PFEs use on the job. David Peter Hansen responded with this great list of tools for Performance Troubleshooting. I’m definitley adding it to my suggested links.

Get Started with Query Store

One of the newest features that everyone is talking about with Azure SQL Database or SQL Server 2016 is the Query Store which provides a mechanism of capturing query performance over time and persisting it with the database. I’m still trying to figure it out myself, but a great place to start is from…

FREE Plan Explorer

SQL Sentry is introducing the new unified Plan Explorer! This edition includes all features of Plan Explorer PRO, plus two new and incredibly powerful features: Index Analysis and Performance Profiling. These new features were originally going to be part of Plan Explorer ULTIMATE at higher price point. However, they ultimately decided…

SQL Server Startup Options

Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless you are troubleshooting the Database Engine. It might also be useful to add trace flags to a startup options. Trace flags are used to temporarily set…

Wait Type Library

Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005. This will be extremely important to all the Performance Tuners out there to really understand what is slowing your SQL code down. I can’t believe…

Wait Statistics Guide

Wait a minute… How could I have a week of favorite performance tuning resources without including one of my favorites. That’s right we are visiting SQL Skills again for this excellent Beginner’s Guide to Performance Tuning using Wait Statistics written by Jonathan Kehayias and Erin Stellato.

Data Storage Internals

Wrapping up my week of Query Optimization page recommendations and while SQLity.NET  does have a lot of information on Query Optimization, it is an older series that they ran on Wednesdays about How SQL Server Stores Data that I am recommending today. This series really digs deep into the world of Data Storage…

Query Optimization Papers

When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to research and write his Query Optimizer book and which research papers he recommend to learn more about query optimization.