Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance.
SQL SERVER – Query for CPU Pressure
How do I actually measure the CPU for the entire server? In today’s blog post we will discuss Query for CPU Pressure and its script to identify the same.
SQL SERVER – Scheduler_ID with Large Number in dm_os_schedulers
The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers.
Task Manager – Confusing Story of CPU
Clients hired me to help with the Comprehensive Database Performance Health Check. We will talk about a very Confusing Story of CPU of Task Manager.
SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism
One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries
Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.
SQL SERVER – Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint
I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.