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 row of glass jars with different water levels along a wall, one under a vermilion funnel

Waits Since Restart: A Wait Stats Query With Uptime Rates

March 8, 2021
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Wait Stats

Waits since restart show where a SQL Server spends its waiting time. One query ranks the real waits, removes the idle ones, and adds the average wait, the signal share and a rate per hour of uptime. A table maps the common waits to the area to check next.

Read More
Gouache painting of a small vermilion boat on a calm river beside a row of small wooden carts waiting on the bank

RESOURCE_SEMAPHORE vs THREADPOOL: Two Waits, Two Fixes

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

RESOURCE_SEMAPHORE vs THREADPOOL tells you whether a task waits for memory or for a worker thread. This post reads both counters and checks for live waits. A demo shows how an index shrinks a memory grant from 38,216 KB to zero.

Read More
Gouache painting of a heaped woodpile beside a neat stack of logs on a vermilion pallet

Index Build Speed: Which Rebuild Settings Change the Time

March 1, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL TempDB

Index build speed depends on rebuild or reorganize, MAXDOP, ONLINE, SORT_IN_TEMPDB and the recovery model. This post times each choice on a million row table and measures the log under each recovery model. It shows which one changes the clock and which changes only the log.

Read More
Gouache painting of a crowded kitchen counter of vegetable bowls with an extra cart beside it, one bowl vermilion.

Internal Temporary Tables in MySQL: When a Query Spills to Disk

February 11, 2021
Pinal Dave
SQL Performance
MariaDB, MySQL, SQL Performance, SQL Scripts

MySQL and MariaDB build internal temporary tables behind your back for GROUP BY, DISTINCT, UNION and derived tables. This post counts them with status counters, reads them in EXPLAIN, shows what pushes one to disk, and removes one with an index.

Read More
A missing courtyard stepping stone leads through a red-ribboned side path to the relocated slab.

SQL SERVER – Finding Fragmentation in Forwarded Records

February 9, 2021
Pinal Dave
SQL Performance
SQL Data Storage, SQL Heap, SQL Scripts, SQL Server

Finding Fragmentation in a heap also requires a separate check for forwarded records. I measure their effect before choosing maintenance.

Read More
Gouache painting of a bakery bench with trays and bowls beside a small vermilion side table holding a few cookie cutters

Room for an Index Build: Free Space and TempDB Placement

January 19, 2021
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL TempDB

Room for an index build is the free space that your database and tempdb need before the build starts. This post estimates the index, checks both places, breaks a build on purpose, and shows what SORT_IN_TEMPDB moves and what it leaves in your database.

Read More
Birds spaced along a power line except around one red insulator where dozens crowd together

Finding the Indexes Behind Lock Waits With Operational Stats

January 18, 2021
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Lock, SQL Wait Stats

Rank indexes behind lock waits with operational stats, separate latches from locks, and test targeted access or row versioning fixes.

Read More
Previous 1 … 17 18 19 20 21 22 23 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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