This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Question: Do Queries Always Respect Cost Threshold of Parallelism?
SQL SERVER – List Query Plan, Cache Size, Text and Execution Count
I love the curious questions from people who attended the class. Here is one such question during recent SQL Server Performance Tuning Practical Workshop. Let us see the question which I received about the Query Plan.
SQL SERVER – Difference Between Status in SP_Who2 – Running, Pending, Runnable, Suspended, Sleeping
One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards to CPU.
SQL Monitor 9 – Proactively Monitor Large SQL Server Estates
The way it works out in most cases is, when organizations are small, the team put in place rock-solid plans to monitor their servers.
Changing Trends & Technology – Challenging DBAs
The biggest challenge as any technologies is that while you are getting super specialist at what you do, the world around you move so much ahead that when you look outside your windows you feel that you are expert at the technology which is actually history. This is indeed true in the world of changing trends and technology.
Business Secrets in SQL Server Performance Tuning Practical Workshop for EVERYONE
Lots of people often ask me – What Will Attendee Learn in SQL Server Performance Tuning Practical Workshop for EVERYONE scheduled on April 23rd, 2019? The answer is pretty straight forward – my business secrets.
SQL SERVER – Priority Boost and SSMS 18
Just the other day, I had a very interesting experience while using the latest SQL Server Management Studio 18.0 preview 7 (SSMS 18.0) during one of the Comprehensive Database Performance Health Check. My client said they have realized that SQL Server does not have settings of Priority Boost settings available in SQL Server anymore. Actually, this is not true, let us quickly understand the same.Â
How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216
Question: How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server?
SQL SERVER – Default Worker Threads Per Number of CPUs
During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads.