SQL DBA Blog: Home

  • LATCH_NL Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No, and you should never see it with a non-zero value; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if…

    Read More

  • DBA Scripts: Get Index Fragmentation

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Index Maintenance Index fragmentation is one of those topics where the received wisdom, “rebuild your indexes every weekend”, causes almost as many problems as it solves. Rebuilding an index that doesn’t need it wastes a maintenance window, takes a…

    Read More

  • LATCH_SH Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX, TempDB Allocation ContentionRelated pillar: Performance & Troubleshooting ⚡LATCH_SH is a thread waiting to read an internal structure that is not a data page, because another thread holds it exclusively. The name does not say which structure; the latch class does.…

    Read More

  • LATCH_UP Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Rarely on its own; our SQL Server 2025 lab had 9 waits totalling 2 ms. Get Wait Statistics does not filter it out, so if it ranks, you will see…

    Read More

  • LOGBUFFER Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: WRITELOGRelated pillar: Storage & Capacity ⚡LOGBUFFER is a session waiting for space in the log buffer to store a log record, because buffers are not being flushed to disk fast enough. Consistently high values might mean the log devices cannot keep…

    Read More

  • LOGMGR_FLUSH Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: WRITELOG Wait TypeRelated pillar: Backup & Recovery Is It a Problem? Rarely on its own. It is not reported as a contention point; on our SQL Server 2025 lab it had about 1,800 waits averaging under a millisecond. Get Wait Statistics…

    Read More

  • Unable to Open the Physical File (Error 5120)

    SQL Server error 5120 reports an operating system error, and error 5 has two completely different causes: the file is already open, or the service account cannot read it. The message cannot tell them apart.

    Read More

  • PAGEIOLATCH_UP Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGEIOLATCH_SH Wait TypeRelated pillar: Storage & Capacity ⚡PAGEIOLATCH_UP is a thread waiting for a page, usually an allocation page, to come in from disk so it can change it. Like the rest of the family, it is judged by its average…

    Read More

  • DBA Scripts: Get Autogrowth History

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity SQL Server autogrowth is one of those settings that is often ignored until it becomes a production problem. A database file growing during normal business hours is usually a sign that SQL Server is reacting to a capacity issue. The…

    Read More

  • PAGELATCH_DT Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Practically never. Expect zero or close to it; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks, you…

    Read More

Major pillars
DBA ScriptsEvery script, one page each SSMS Complete GuideInstall, shortcuts, git, Copilot, dark mode Error LibraryLook up an exact message, cause and fix Wait Types LibraryWhat the server was waiting on Site MapHow the pillars, areas and scripts connect
Quick scripts
Get-ActiveSessions Get-UserPermissionsAudit Get-DiskSpace Get-DatabaseFreeSpaceSummary Get-IndexFragmentation Get-AvailabilityGroupLatency Get-BackupCoverage Get-BackupRestoreProgress
Patch week
SQL Server BuildsLatest CU per version, with support dates Patch LevelWhat your server is running
Health check & AI
Full Health CheckCollect 45 diagnostics, apply rules, then an AI assessment sqldba MCP ServerGive an AI assistant a verified SQL Server reference
Script areas
Server & Configuration Storage & Capacity Backup & Recovery High Availability Performance & Troubleshooting Security Maintenance & Automation Migration & Deployment
Latest posts
Browse by topic