Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647
Active and Inactive VLFs: List Them for Every Database
To list active and inactive VLFs for every database, count the rows of sys.dm_db_log_info by vlf_active and read the log reuse wait next to them. This post builds a demo log with 24 VLFs, shows how an open transaction and small autogrowth steps add more, and fixes the count with one shrink and one regrow.
Autogrowth Settings: Check Every Database File in SQL Server
To check autogrowth settings for every database file, read sys.master_files and turn its raw page counts into sizes you can judge. This post builds a demo database with three differently set files, reports the current size, the next growth step and the room left, and fixes the weak settings. It also explains why the same query can return no rows.
SQL SERVER – Regular Table or Temp Table – TempDB Logging Explained
After the blog posts about temp and regular table, I have received questions about it hence I am writing this blog post about TempDB Logging.
Database Mail Health Check: Unsent Items and the Event Log
The alert job succeeded, yet nobody got the email. Here are three read-only checks that show whether Database Mail is really working.
SQL SERVER – Error 35296: Log Backup for Database “SQLAuthority” on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database
Error 35296: log backup on a secondary replica failed because the new backup information could not be committed on primary. Here is the cause I found.
Performance Condition Alerts: Warnings Before a Log File Fills
Build performance condition alerts for log usage, tempdb free space, and blocking, with sensible delays and an operator response.