March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
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
Query Ignoring

Query Ignoring CPU Threads – SQL in Sixty Seconds #161

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

I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.

Read More
OS Threads

SQL SERVER – OS Threads Used by SQL Scheduler

May 7, 2021
Pinal Dave
SQL Tips and Tricks
CPU Scheduler, CPU Threads, SQL Scripts, SQL Server

Today we will answer the question asked by my client during  Comprehensive Database Performance Health Check, about OS Threads Used by SQL Scheduler.

Read More
OS Thread ID

SQL SERVER – Map SQL Server Session ID to OS Thread ID

April 14, 2021
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL Scripts, SQL Server

He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID. 

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

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

Go to mobile version