Tag: Performance Troubleshooting

Remove High Virtual Log File (VLF) (@OptimizeLogFiles) This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is

Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer

Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal.

Hi Friends, Ever wanted to check heartbeat of SQL Server. It is very common activity for a SQL Server user to check CPU, SQL Memory Utilization, Available Memory

I often see DBAs/developer struggling to find what’s wrong with query. The first step in troubleshooting queries is finding out information like batch text, query text, batch execution

Many times I have seen that DBAs feel like its OK to Shrink Log files in order to release space, and they perform this activity in SQL Agent

Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data collected from First Responder Kit. In case you are not familiar with what