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
A barnacle colony spreading across a dinghy hull with a finite strip of bare wood remaining

Forecasting the Disk-Full Date From a Daily File Size History

August 9, 2023
Pinal Dave
SQL Tips and Tricks
Disk, File format, SQL Server

Free space today cannot tell you when the drive fills up. Save daily file sizes and let a short query turn the growth into a date.

Read More
A nearly empty grain bin with a scoop in a barn, a field of ripening wheat seen through the open door

Finding Oversized Data Files With Lots of Free Space

March 8, 2023
Pinal Dave
SQL Tips and Tricks
DBA, Disk, Shrinking Database, SQL Data Storage

Identify oversized data files with FILEPROPERTY, separate internal free space from disk capacity, and review one-time shrink choices.

Read More
Gouache painting of a ready blank canvas on an easel beside a primed canvas and a pot of vermilion paint

Log File Growth and Instant File Initialization: The 64 MB Rule

February 24, 2023
Pinal Dave
SQL Tips and Tricks
Disk, SQL Server 2022, SQL Server Configuration, Transaction Log

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.

Read More
Gouache painting of three hourglasses side by side, the first with grey sand and the other two with vermilion sand

Database File Latency: Read and Write Stalls per IO

June 7, 2022
Pinal Dave
SQL Performance
Disk, SQL DMV, SQL Performance, SQL Scripts

Database file latency is the stall time per read or write. This post divides the IO stall columns by the call counts for every file, explains the zero queued columns and says when a number is worth acting on.

Read More
A lemon squeezer holding a small lemon half beside an oversized half that cannot fit its pressing cup

Will the Next Autogrowth Fit? Checking Growth Against Free Disk

February 9, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, Disk, SQL Server

The drive has free space, yet the file will not grow. Here is how to calculate the next autogrowth and test it against disk and MAXSIZE.

Read More
A caddie drawing the next club from a golf bag while the golfer is still walking toward the ball

Read-Ahead Reads in STATISTICS IO: What They Tell You

May 26, 2021
Pinal Dave
SQL Performance
Disk, SQL Performance, SQL Scripts, SQL Server

Interpret read-ahead reads in STATISTICS IO, compare isolated cold scans and seeks, and separate prefetch from storage-wait evidence.

Read More
Gouache painting of a basket of fresh peaches beside a shelf of preserve jars, some with cloth tops, one deep red jar

CHECKPOINT Covers One Database: Flush Data to Disk

March 19, 2021
Pinal Dave
SQL Performance
Disk, SQL Memory, SQL Scripts, SQL Server

CHECKPOINT covers one database, so to flush data to disk you run it in each database. A demo with two databases shows one flushed and one still dirty. A short script then flushes every database in one pass, and the post says when a flush is worth it.

Read More
1 2 3 4 5 Next
  • Books
  • Testimonials
  • Privacy Policy

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