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

Should we check [context_switches] for SQL Server Query from Performance Point

Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal. Thanks Friends!…

Ajay Dwivedi May 27, 2018

Database Administration

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren's Maintenance Solution is my favorite. Two…

Ajay Dwivedi April 24, 2018

Health Check TSQL

SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics

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 below TSQL…

Ajay Dwivedi April 19, 2018

Errors TSQL

Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the…

Ajay Dwivedi April 15, 2018

Execution Plan Health Check

[sp_HealthCheck] – Get SQL Server Health Details

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, Available Memory…

Ajay Dwivedi March 31, 2018

Execution Plan Health Check Performance Tuning

What’s Running – Find All Details of Running Queries

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 plan, individual…

Ajay Dwivedi March 30, 2018

Internals

Myth – Shrinking Log Files is OK

Many times I have seen that DBAs feel like its OK to Shrink Log files in order to release space, and they perform this activity in SQL Agent job. In…

Ajay Dwivedi March 28, 2018

Performance Tuning

First Responder Kit Power BI Dashboard

Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data collected from First Responder Kit. In case you are not familiar with what it is,…

Ajay Dwivedi February 8, 2018

Execution Plan Performance Tuning

Procedures with RECOMPILE Option

Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE option without even understanding it thoroughly. Instead of resolving the performance issue by query tuning,…

Ajay Dwivedi January 7, 2018

Database Administration

How to Verify Given Access/Permissions to User/Login

Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing access/permissions. This is not required since we have very easy way to verify user permissions.…

Ajay Dwivedi November 8, 2017