[Script Of Apr. 18] How to gather SQL Server blocking information to troubleshoot blocking issues

  • Article

image

Apr.

18

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-gather-SQL-Server-450c90e3.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This script is to gather SQL Server blocking information to troubleshoot blocking issues.

Sometimes, people want to find if there is any block in their SQL Server. So we provide this script to demonstrate how to achieve this goal. We will create a block first and then use this script to find the block information. Please do it in a test environment.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery