After sending out the previous email where I explained that anyone who will attend SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE, will get 1 Hour FREE Consulting Hour, it seems that many of you have signed up for the course – Thank You! As per organizers, now there are only very few seats are available.
Solve 3 Biggest SQL Server Performance Challenges with Spotlight
My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces. Today we will discuss why I prefer to use Spotlight to identify SQL Server Performance issues and their resolutions.
SQLBits 2019: Attention Pre-Con Attendees – One Free Consulting Hour
SQLBits 2019 is one of my most favorite events.
If you are going to go to SQLBits 2019, you want to come to my pre-con about 21 Essential Scripts: Performance Tuning for EVERYONE. This pre-con contains best of my material and goes beyond what you conventionally know about any topic. It is no-nonsense, direct to demonstration and fast-paced advanced class where we discuss 21 essential scripts for SQL Server Performance Tuning.
SQL SERVER – Cleanup Plan Cache For a Single Database
During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database. After making the improvements in the database, we reached to the point where we needed to clear the cache of the server to see how our improvements fairs with the changes which we have made.
SQL SERVER – How to Optimize Your Server Performance by Reducing IO Waits?
SQL Server performance tuning is often considered as a complex subject and many DBAs and Developers often sees SQL Server Engines as a black box. However, the reality is very different as SQL Server Performance tuning is often a simple art of balancing three of the important resources for any system – 1) CPU, 2) Memory and 3) IO. In this blog post, we will discuss how we can reduce critical waits for queries and optimize server performance.
SQL Server Performance Tuning Practical Workshop – Relaunched
In the year 2017 just for an experiment, I decided to start a SQL Server Performance Tuning Practical Workshop. I had no idea, that I will be the biggest and most popular service delivered by SQLAuthority.com. Since the year 2017, I have been delivering one or two workshops every week.
SQL SERVER – Parallelism for Heap Scan
Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the Comprehensive Database Performance Health Check engagement about Parallelism for Heap Scan.