Troubleshooting Archives - Page 4 of 5 - Performance Tuning And Infra Automation

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 authenticated GMail account. Even after setting up mail profile as per standard configuration (same as…

Ajay Dwivedi September 10, 2017

Performance 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 personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by Brent Ozar…

Ajay Dwivedi July 19, 2017

Internals 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 stats on server, I found 'LCK_M_X' wait to be most prominent wait on server. This…

Ajay Dwivedi July 17, 2017

Errors TSQL

Easy Trick to Debug Long TSQL Codes

In my previous organization, working as Senior SQL Developer, I was often asked for help by fellow colleagues for identifying issues inside long and complex TSQL codes. Finding issues becomes…

Ajay Dwivedi May 6, 2017

Performance Tuning

Log all Activities using sp_WhoIsActive – 2

Hi Friends, in my previous blog post Log all Activities using sp_WhoIsActive, I shared how easy it is to log all sql server sessions using sp_whoIsActive and SQL Server Agent…

Ajay Dwivedi May 4, 2017

Errors Performance Tuning

Analyzing Deadlock Issues

I often receive the question - what is the best way to find issues when client/user complaints of deadlock issues? Msg 1205, Level 13, State 51, Line 10 Transaction (Process…

Ajay Dwivedi February 21, 2017

Errors

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 databases on development sql server. So I started checking SQL Server Error logs to find…

Ajay Dwivedi January 28, 2017

Errors

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. Job history suggested that the job has been continuously failing for past 15 weeks. But,…

Ajay Dwivedi January 9, 2017

Performance Tuning TSQL

Optimize for Value – TSQL Query Hint

Today, I was working on an incident of slow running procedure. Procedure was running fine for most of the parameter values but, was getting stuck for few values. I could…

Ajay Dwivedi January 3, 2017

Performance Tuning

Log all Activities using sp_WhoIsActive

It is not a new thing for a DBA to check what's running currently on server in order to figure out issues. My personal favorite tool for finding out current…

Ajay Dwivedi December 28, 2016