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

Navigating SQL Server CPU and Memory Usage Woes

August 23, 2023
Pinal Dave
SQL Tips and Tricks
Idera, SQL CPU, SQL Memory

SQL Server is a powerful database management system, it can encounter performance issues related to CPU and memory usage.

Read More
non-yielding

SQL SERVER – Troubleshooting Non-Yielding Scheduler Issues

July 10, 2023
Pinal Dave
SQL Performance
CPU Scheduler, Lock Pages in Memory, SQL CPU, SQL Memory

During the engagement, I encountered a critical issue related to non-yielding schedulers in their SQL Server environment.

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

SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance

June 26, 2023
Pinal Dave
SQL Performance
Compatibility Level, Database Scoped Configurations, MAXDOP, Parallel, Query Store, SQL CPU, SQL DMV, SQL Server 2022, SQL Server Configuration

SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).

Read More
parallel index operations

Configuring Parallel Index Operations in SQL Server

May 31, 2023
Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL Index

Configuring parallel index operations in SQL Server can significantly impact query performance and scalability. During my popular service, we discuss.

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
1 2 3 4 … 10 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version