One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.
Large Memory Servers: How SQL Server Scans the Buffer Pool
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.
SQL Server 2022 Performance – Buffer Pool Scan
One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.
PSPO Plan Variants: One Query, Several Plans in SQL Server
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.
VLF Growth Rules: How Many Virtual Log Files One Growth Adds
The VLF growth rules say how many virtual log files one log growth adds: one up to 64 MB, eight up to 1 GB, sixteen above. This post measures them on a demo database, shows a log with 68 VLFs from 1 MB steps, and repairs it by shrinking and growing once.
Log File Growth and Instant File Initialization: The 64 MB Rule
The 64 MB rule says log file growth can skip zeroing when instant file initialization is on, but only up to 64 MB. Two trace flags make the SQL Server error log show a 64 MB growth skipping the zeroing and a 65 MB growth zeroing in full. The last section says what to change.
Approximate Percentiles With APPROX_PERCENTILE_CONT
Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.