Query Tuning Archives - Page 2 of 3 - Performance Tuning And Infra Automation

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

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

Database Administration

Setup fresh/Scriptout Existing Mirroring on SQL Server

In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or dropping the…

Ajay Dwivedi January 25, 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

Execution Plan Performance Tuning TSQL

Query Optimization 03 – Users statistics (individual user) [StackOverflow]

Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog post Questions and Answers per Month, we took optimization decision by analyzing warnings suggested by…

Ajay Dwivedi November 27, 2016

Execution Plan Performance Tuning

Query Optimization 02 – Questions and Answers per Month [StackOverflow]

Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog post What is my accepted answer percentage rate, we took optimization decision based on Logical…

Ajay Dwivedi November 21, 2016