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.
SQL Authroity News – Optimizing Lazy Spool – PASS Blog
I will be presenting a day-long pre-conference at SQLPASS on the topic – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs and regular session as well. Lots of people are asking me what I will be covering in the session, so I have decided to give sneak preview about it on the blog of PASS.
SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL
As you might already know that I am a SQL Server Performance Tuning Expert who also acts as a “on-demand consultant” for many organizations across the world who have performance tuning or any other issue related to SQL Server. Once I was working with one of my clients and their DBA asked a question. In this blog, we would learn about possible ways to handle a situation where DBCC CHECKDB is indefinitely waiting for PREEMPTIVE_OS_DEVICEIOCONTROL.
SQL SERVER – Database Performance Analyzer – Table Tuning Advisors
I am a SQL Server Performance Tuning Expert and I consultant with multiple organizations across the world when they have performance tuning issues. I am often showed one or more of the tables of the system and asked to tune system around those tables. The task of table tuning is very challenging.
SQL SERVER – Query to Find the Longest Running Function – Function Elapsed Time
I love my job of SQL Server Performance Tuning and Optimization consultant as every single day I walk into the customer door (well, to be honest, it is actually virtual door of GoToMeeting), I face new challenges and learn new ways to tune SQL Server. In this blog post, we will discuss Query to Find the Longest Running Function.