Posted inPerformance Tuning SQLMonitor
Live Troubleshooting High CPU on SQL Server – Part 3
Resolve High CPU Issue on SQL Server with SOS_SCHEDULER_YIELD & PAGELATCH Waits
Troubleshooting High CPU on SQL Server – Part 2
Troubleshoot CPU Issue on SQL Server using SQLMonitor
Troubleshooting SQL Server with High Memory Grants
Troubleshoot SQL Server Memory Related Performance Issues using Free Tools
Posted inExecution Plan Performance Tuning TSQL
Question/Answer – Should I filter the data in Sub Queries??
Recently a good friend of mine asked me question whether is there any performance benefit…
![Should we check [context_switches] for SQL Server Query from Performance Point](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/05/Context-Switches.png?fit=1024%2C252&ssl=1)
Posted inPerformance Tuning TSQL
Should we check [context_switches] for SQL Server Query from Performance Point
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server…
![[sp_HealthCheck] – Get SQL Server Health Details](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/sp_HealthCheck.gif?fit=1024%2C500&ssl=1)
Posted inExecution Plan Health Check
[sp_HealthCheck] – Get SQL Server Health Details
Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very…
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
Posted inExecution Plan Performance Tuning
Procedures with RECOMPILE Option
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE…
Posted inPerformance Tuning TSQL
Common Myth: Loop is Always Faster than Cursor
From past few weeks, I have been taking interview for Sr. SQL DBA position in…
Posted inPerformance Tuning Powershell TSQL
Deploy SQL-Server-First-Responder-Kit with Powershell
There are many tools in market that can help you troubleshoot in specific situations. My…