When I joined my current organization 2 years back, the biggest problem I faced as DBA was whenever there was Replication, log shipping, Mirroring, or AlwaysOn, the Index
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.
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
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
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE option without even understanding it thoroughly. Instead of resolving the performance issue by
From past few weeks, I have been taking interview for Sr. SQL DBA position in my team. What I found is, even candidates saying that they have expertise
There are many tools in market that can help you troubleshoot in specific situations. My personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by
