There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
Question: How to Execute Query Without Using F5 or Query Toolbar in SSMS?
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an error. One of the most common questions I receive during Comprehensive Database Performance Health Check is how to get the last known actual execution plan for a previously cached query plan.
SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for quick consultation using On Demand offering.
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
One of my clients was trying to automate SQL deployment. While testing they were stuck with an interesting error and then they contacted me. In this blog, I would share my learning about an installation error: System.ArgumentNullException – Value cannot be null.
SQL SERVER – How Do I Evaluate Monitoring Tools?
Today, I am going to talk about the 3 important properties which I look for in all the SQL Server Performance monitoring tools.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. Today I will share another script which I have written which I frequently use with my consulting engagement Comprehensive Database Performance Health Check.
SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2
I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of the third party application for the client is not closing the connections which they open after completing the transactions. This was negatively affecting their performance. We immediately opened the ticket with the third party application and while they provide the solution after patching the application we decided to kill all the inactive sessions.
Dirty Pages – How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server? Answer: I received question today during my SQL Server Performance Tuning Practical Workshop.
SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint
During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.