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
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