Posted inErrors
Error/Fix: Database Mails using Gmail getting to Unsent Items
Recently I tried to setup Database Mail profile in SQL Server 2016 instance using 2-Step…
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…
Posted inInternals Performance Tuning TSQL
Non – Trusted Foreign Keys in SQL Server
Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait…
Easy Trick to Debug Long TSQL Codes
In my previous organization, working as Senior SQL Developer, I was often asked for help…
Posted inPerformance Tuning
Log all Activities using sp_WhoIsActive – 2
Hi Friends, in my previous blog post Log all Activities using sp_WhoIsActive, I shared how…
Posted inErrors Performance Tuning
Analyzing Deadlock Issues
I often receive the question - what is the best way to find issues when…
Posted inErrors
Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database
Recently I received an incident for low disk space on mount point dedicated to system…
Posted inErrors
Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete
Recently I received an incident for CheckDB job failure on one of our production server.…
Posted inPerformance Tuning TSQL
Optimize for Value – TSQL Query Hint
Today, I was working on an incident of slow running procedure. Procedure was running fine…
![Result Set of [sp_WhoIsActive]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/12/Log_Activities-02-1.png?fit=1024%2C437&ssl=1)
Posted inPerformance Tuning
Log all Activities using sp_WhoIsActive
It is not a new thing for a DBA to check what's running currently on…