sql-server Archives - Page 5 of 8 - Performance Tuning And Infra Automation

[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

TSQL

[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy

DBAs! We all know the pain of creating new data or log files at new location when files on old location are about to full. Post that we have to…

Ajay Dwivedi March 24, 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

Errors

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 TSQL

Common Myth: Loop is Always Faster than Cursor

From past few weeks, I have been taking interview for Sr. SQL DBA position in my team. What I found is, even candidates saying that they have expertise in Performance…

Ajay Dwivedi July 22, 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