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
SQL Server Live Health Check
Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor
Posted inHealth Check TSQL
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using sp_WhoIsActive
As a DBA, I often receive user requests to check server slowness. Quite often, slowness is directly linked with active blocking on the server. I find many scripts on internet…
Posted inBaseline-SQL-Server Health Check
Baseline SQL Server
Hi DBA friends! Like me, if you are responsible for multiple SQL Servers and don't have any third-party monitoring tool, then I guess instead of writing your own in-house tool,…
Posted inHealth Check TSQL
SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics
Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created below TSQL…
![[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 common activity for a SQL Server user to check CPU, SQL Memory Utilization, Available Memory…
Posted inExecution Plan Health Check Performance Tuning
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 troubleshooting queries is finding out information like batch text, query text, batch execution plan, individual…