August 2022 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
RESOURCE SEMAPHORE

SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL

March 2, 2021
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, Memory Grant, SQL CPU, SQL Memory, SQL Server, SQL Wait Stats

RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.

Read More
16 CPU

SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142

November 10, 2020
Pinal Dave
SQL Video
CPU Threads, Execution Plan, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.

Read More
SQLOS Scheduler

SQL SERVER – SQLOS Scheduler and the Process States

September 14, 2020
Pinal Dave
SQL Server
CPU Scheduler, CPU Threads, SQL CPU, SQL Server, SQL Wait Stats

I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.

Read More
Parallel Queries

List All Parallel Queries – SQL in Sixty Seconds #098

August 12, 2020
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, Parallel, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.

Read More
Visible Offline

SQL SERVER – Visible Offline Scheduler and Performance

May 12, 2020
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL DMV

Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance. 

Read More
cpu pressure

SQL SERVER – Query for CPU Pressure

April 2, 2020
Pinal Dave
SQL Performance
CPU Threads, SQL CPU, SQL DMV, SQL Scripts, SQL Server

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.

Read More
Large Number

SQL SERVER – Scheduler_ID with Large Number in dm_os_schedulers

March 13, 2020
Pinal Dave
SQL Performance
CPU Threads, SQL CPU, SQL DMV, SQL Scripts, SQL Server

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.

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

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

Go to mobile version