This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a single millstone with a line of grain sacks waiting and the first sack in vermilion

Signal Waits: Detect CPU Pressure With Wait Statistics

August 12, 2019
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Wait Stats

Signal waits are the part of every wait that a task spends in the queue for a free CPU. This post ranks the wait types by signal time, shows why timer waits ruin the total share, and samples the signal share into a small table so a whole working day can be read interval by interval.

Read More
Gouache painting of a water mill with a raised sluice gate and a vermilion wheel to lift it

THREADPOOL Waits: When Raising Max Worker Count Helps

August 9, 2019
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Server Configuration, SQL Wait Stats

THREADPOOL waits mean tasks waited for a worker thread. Five read-only queries separate real thread starvation from blocking and busy CPUs. The post lists five signs and shows how to raise the cap in small steps.

Read More
A giant pumpkin filling half a harvest table, small squashes set apart in their own basket.

Filtered Statistics: Fixing Estimates for Skewed Data

July 31, 2019
Pinal Dave
SQL Performance
SQL Performance, SQL Server, SQL Statistics

Use filtered statistics to describe skewed customer values, inspect histograms, and test estimates under literal and parameterized queries.

Read More
A restricted valve limits flow from a large vessel into a smaller receiving basin.

SQL SERVER – Query Specific Wait Statistics and Performance Tuning

July 25, 2019
Pinal Dave
SQL Performance
Resource Governor, SQL Memory, SQL Server, SQL Server Management Studio, SQL Wait Stats

Query Specific Wait Statistics helped explain a sudden customer-query slowdown. The remaining workload ran normally, and recompilation had not helped.

Read More
Gouache painting of a wall of cubbyholes each holding one boot and a vermilion boot waiting at an occupied cubby

Unique Index Performance: What a UNIQUE Index Saves

July 24, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts

Unique index performance gains come from what the optimizer learns, not from smaller pages. A tested demo compares pages, reads, plans and CPU for a plain index and a unique index. It also shows the error a duplicate causes.

Read More
Gouache painting of a bare kitchen counter with one vermilion jar brought back from the pantry

DBCC DROPCLEANBUFFERS Impact on Memory: See a Cold Cache in Action

July 11, 2019
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server DBCC

DBCC DROPCLEANBUFFERS removes every clean page from memory, so the next query reads from disk. This post counts the pages of one database before and after, shows why a CHECKPOINT comes first, and compares a cold read with a warm read.

Read More
Gouache painting of a sand timer with vermilion sand between two trays of pears on a wooden table

CHECKPOINT Impact on Memory: Watch Dirty Pages Go to Zero

July 3, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Scripts

CHECKPOINT impact on memory is easy to measure. This post counts the dirty and clean pages of one database before and after a checkpoint. Dirty pages drop to zero, the clean pages grow by the same amount, and nothing leaves memory.

Read More
Previous 1 … 38 39 40 41 42 43 44 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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