Category: Performance Tuning

Resolve high cpu issues on SQL Server using Open Source tools

Troubleshoot SQL Server Memory Related Performance Issues using Free Tools

Build desktop for running SQL Server Lab setup.

Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor

Are you tired of not knowing what is usual workload of your server? Do you want to know what is speed of your server? If you are a

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