Category: WhatIsRunning

Troubleshoot CPU Issue on SQL Server using SQLMonitor

Troubleshoot SQL Server Memory Related Performance Issues using Free Tools

Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor

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

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

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

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,

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