May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL in Sixty Seconds – CPU Threads and Uneven Workload

January 2, 2025
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, SQL CPU

When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.

Read More
thread pool

SQL SERVER – Thread Pool Waits: Monitoring and Optimization

June 30, 2023
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL Wait Stats, Threadpool

Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks.

Read More
Thread Management

SQL Server 2022 – Thread Management for Performance Improvement

May 26, 2023
Pinal Dave
SQL Performance
CPU Threads, SQL CPU, SQL Memory, SQL Performance

I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.

Read More
Waiting On Disk

SQL SERVER – CPU Scheduler Waiting On Disk

September 21, 2021
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL Scripts, SQL Server

Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.

Read More
counted

SQL SERVER – Threads Not Counted for Max Worker Threads

August 31, 2021
Pinal Dave
SQL Tips and Tricks
CPU Scheduler, CPU Threads, SQL Scripts, SQL Server

I had a very interesting situation where I had to find all the threads which are not counted for max worker threads in SQL Server. Let us see the script.

Read More
Maximum Worker Threads

Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170

June 1, 2021
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.

Read More
Get CPU Details

Get CPU Details – SQL in Sixty Seconds #164

May 14, 2021
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.

Read More
1 2 3 4 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version