What is SQL Server parameter sniffing and data skew?
Performance Tuning
How do I fix this?
If you found this page you most likely either found yourself in the middle of a SQL Server parameter sniffing and/or data skew issue and have no idea how to get yourself out of this hole. In the eight-minute video below…
Why is my SQL Server query slower than normal?
Performance Tuning
Have you ever had a query that runs frequently start to randomly go slower? We all have and without the proper tools and knowledge, this can be hard to figure out because there can be so many different reasons. In this blog post, our goal is…
Automatic Tuning: Scalar Functions in SQL Server 2019
Performance Tuning
With SQL Server 2017 Microsoft improved the journey towards making your code go faster without any code changes required by your developers. SQL Server 2019 gives you more of this super cool black magic.
Today, we are going to show…
SQL Saturday Denver 2018 Resources
Performance TuningI had a blast speaking at SQL Saturday Denver. To help everyone moving to SQL Server 2017 I have included my slides and demo code below. If you end up having any questions with the code or need help feel free to contact me.
SQL…
Automatic Tuning in the Real-World
Performance Tuning
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster. Microsoft’s marketing team even jumped on…
GroupBy Conference Resources: demos and source codes.
Performance TuningI hope everyone enjoyed my session on Making Your Queries Go Faster as much as I did planning and delivering it. If you would like to replay the demos on your time you can grab the slide and code . When you go through the demos, if you have…
SQL Saturday Chicago
General, Performance TuningLast weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends. My talk was on Automating the Pain Away with Query Store and Automated Tuning. I hope this…
Finding Top Offenders with Extended Events
General, Performance TuningThis week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get…
Resources for Performance Tuning Article
Education, Performance TuningThe following are some resources that are included in John Sterrett's Introduction to Performance Tuning with Azure SQL Databases Idera Geek Sync.
Performance Root Cause Analysis Toolkit
Calculate DTU on Your Own
Benchmark Azure SQL Database…
Introduction to Performance Tuning in Azure SQL Database
Community, Performance TuningAre you interested in performance tuning in Azure SQL Database? You are in luck! Procure SQL’s very own founder, John Sterrett [t,b] is giving an Introduction to Performance Tuning Azure SQL Databases in Idera’s April 26th GeekSync! …