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

A Curious Case of Orphan User

Hi Friends, Today at work I received an access request to provide multiple database permissions to multiple AD groups on servers. After providing appropriate db roles membership to requested AD…

Ajay Dwivedi November 30, 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

Database Administration Errors

Error/Fix: The Extended Events session named “blocked_process” could not be found.

Two days back while I am presenting in a KT session within team on how to use Extended Events for trapping blocking and deadlocks, and use the SQL Sentry Plan…

Ajay Dwivedi November 24, 2016

TSQL

Script to Analyze Mount Point Space & Generate Shrink File Statements

In my organization, we often receive far too many incidents for low free disk space. As part of resolution we have to check for unexpected files/folders on the mount point…

Ajay Dwivedi November 20, 2016