PowerShell – Email All Users Connected (Logged In) To A SQL Server Instance

As a DBA, when I have to do an emergency restart of a SQL Server instance or the host itself, the first thing I do is to check who is connected so that I can notify them (at least the ACTIVE users). We do have a system where we keep the app/database/owner information but notifying … Continue reading PowerShell – Email All Users Connected (Logged In) To A SQL Server Instance

Advertisements

SQL Server: SSMS Says “Lock request time out period exceeded.” – Identify Blocking Source Quickly

Time-tested approach Although I explain the process for table expansion, the troubleshooting steps to find any blocking session is to run sp_who2 and look at the BlkBy column to get the session id that is blocking a┬ásession (assuming you can identify sessions from the information in the other columns) and examine the blocking session. Then … Continue reading SQL Server: SSMS Says “Lock request time out period exceeded.” – Identify Blocking Source Quickly