Checking Database Log Files from Powershell
A while back I had written a post about ahow to check your VLF count for each database on a sql server.
It's all well and good to run this script via ssms, however it does give us some limitations in terms of scripting, and you have to use SSMS. Whi...
How to check your Transaction Log VLF Count in SQL Server
You can probably throw a stone and hit an article about properly maintaining the transaction log.
In fact here are my favorites:
- A Busy/Accidental DBA’s Guide to Managing VLFs
- Transaction Log VLFs – too many or too few?
- 8 Steps to...
How To Find Query Plans for a Stored Procedure in SQL Server
I got tired of trying to find my script to check this, or search through the monitoring tool that we use to find it. I wanted a lightweight tool that I could use to get that one stored procedure that I was being asked to look into.