Pocket Square

First Responder Kit Updates: So Many Updates, Brent Quit

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…
Read More

sp_Blitz® v22: Output Results to a Table, Better Comments, and an App

Our free server troubleshooting tool, sp_Blitz®, just learned some new tricks. If you call it like this: EXEC dbo.sp_Blitz @OutputDatabaseName = ‘DBAtools’, @OutputSchemaName = ‘dbo’, @OutputTableName = ‘BlitzResults’ It will create the table DBAtools.dbo.BlitzResults (if it doesn’t already exist) and insert the results. The table includes columns for the server name and the check date,…
Read More

Introducing the SQL Server Plan Cache (and a Better sp_Blitz®)

When you send your beautifully hand-crafted organic T-SQL statement to SQL Server, the database engine takes a moment to appreciate the poetry of your work.  Before it turns your request into results, it has to build an execution plan.  SQL Server considers: Which tables it needs to join together What subqueries it needs to execute…
Read More

Recognizing SQL Server’s Warning Signs

It’s crucial for database administrators to recognize signs of pending doom.  Make sure you’re able to quickly spot problems in SQL Server Management Studio by studying these screenshots. Databases that haven’t been backed up in 24 hours Databases with old compatibility levels Databases running out of space on the C drive SQL Server with Priority…
Read More

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up.  Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…
Read More