In this free training I have poured my 30+ years of SQL Server experience and personally curate my favorite performance tuning tips, tricks and tactics. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put some speed back into their SQL Server. …
Transcription of Video: Hi, I’m Steve Stedman, with Stedman Solutions, LLC. And one of the things that I wanted to do today was to answer some questions around what we do with a SQL Server health assessment. The screen you’re looking at here is the Stedman solutions, services page on our website. And if we scroll down to the database …
Top reasons for slow SQL Server performance I typically see are: Slow Running Queries, these are queries that run slow even with just one user in the database. Caused by poorly written queries. Caused by missing indexes. > See Database Health Monitor Missing Indexes Report. Caused by out of date statistics for your indexes. Many other reasons. Blocking Queries, where …
CXCONSUMER and CXPACKET are associated with parallelism. When a query that has a cost beyond the cost threshold for parallelism then that query will be split out to be worked on by multiple cores. This is a good thing. It usually means that your queries are taking advantage of multiple cores. Reducing your max degree of parallelism setting is not …
Pre-Register For My NEW Exclusive Performance Training! I used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse …
Pre-Registration is Open – Free Weekly Performance Training Read more »
Every time I do a performance training class I share some stories about those long running reports that I was able to speed up by simply switching a Table Variable (declared with the @ sign) to a Temp Table (declared with the # sign). Today I was working on a batch of TSQL code that took about 8 minutes to …
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the options out there for everyone to see. Hello, I came across your website and it seems that you are an SQL expert, I’m just getting started. I was wondering can you please give some guidance on …
Do you need help with a slow running SQL Server? Take a look at these SQL Server performance tuning options that we offer. Stedman Solutions Performance Tuning