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 huge barn of hay bales with one vermilion bale and a tiny wheelbarrow

Large Memory Servers: How SQL Server Scans the Buffer Pool

May 29, 2023
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Extended Events, SQL Memory, SQL Server 2022

SQL Server scans the buffer pool during startup, backup, restore and DBCC, and large memory servers feel it most. An extended event records the scans, shows which commands start one and how many tasks each uses. The last sections explain what SQL Server 2022 changed.

Read More
Thread Management

SQL Server 2022 – Thread Management for Performance Improvement

May 26, 2023
Pinal Dave
SQL Performance
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
Buffer Pool Scan

SQL Server 2022 Performance – Buffer Pool Scan

May 24, 2023
Pinal Dave
SQL Performance
SQL Memory, SQL Server 2022

One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.

Read More
Gouache painting of a lump of dough beside three baking tins of different sizes, the medium one vermilion

PSPO Plan Variants: One Query, Several Plans in SQL Server

May 15, 2023
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, SQL DMV, SQL Server 2022

PSPO plan variants let SQL Server cache up to three plans for one parameterized query when the data is very skewed. This post builds a skewed table, shows two variants with different reads for three calls, compares the same calls with the feature off, and explains when PSPO does not apply.

Read More
A small vermilion dinghy carrying one tiny parcel across a harbor while dozens more wait on a cargo boat.

Chatty Applications: Finding Many Tiny Queries per Second

April 28, 2023
Pinal Dave
SQL Performance
SQL Counter, SQL Extended Events, SQL Monitoring, SQL Server, SQL Wait Stats

Diagnose chatty applications with batch rates, cached executions, bounded session event counts, and measured round trips per user action.

Read More
Gouache painting of a long pegboard on a table with pliers, a saw, two vermilion-handled hammers, one set crosswise out of line

Performance Tuning Mistakes in SQL Server: 11 Habits to Fix

February 1, 2023
Pinal Dave
SQL Performance
Best Practices, SQL Backup and Restore, SQL Cursor, SQL Index, SQL Statistics

Performance tuning mistakes are habits, and each one has a check. Eleven sit in one table, and five are measured on a demo database: a missing index, stale statistics, a row by row loop, a giant delete and a type that cannot be indexed.

Read More
Two frying pans on a stove, butter sizzling in the hot one and sitting solid in the cold one.

Cold Cache vs Warm Cache: Testing Query Speed Fairly

January 9, 2023
Pinal Dave
SQL Performance
SQL Cache, SQL Memory, SQL Performance, SQL Server, Testing

Compare cold cache and warm cache query tests using isolated buffer clearing, logical and physical reads, and controlled measurements.

Read More
Previous 1 … 8 9 10 11 12 13 14 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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