Identifying and Fixing Parameter Sniffing (Tuesday October 18th, 2016 – 6:00 pm) Presenter: Brent Ozar from Brent Ozar Unlimited You swear nothing changed – but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and…
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…
If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it into a video. Just as a reminder, I will be delivering this presentation at the SQL Saturday in Columbus, Ohio on July 16th and then again…
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 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.
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.
A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?” Well the answer he gives us…
Day two of my favorite posts on SQL Server Query Optimization takes us to Simple Talk and a 2009 blog post from Grant Fritchey and Controlling Execution Plans with Hints. To be honest, while you are there I would check out his book on SQL Server Execution Plans.
Sometimes there are really great posts that explain a topic so well, it is worth sharing. For this next week, I am going to post some of my favorites regarding SQL Server Performance Optimization. Here is a post on Parameter Sniffing where Jes Borland talks about the Elephant and the Mouse problem.