Download Latest Version BlockRec.zip (41.4 kB) Get Updates
Home
Name Modified Size InfoDownloads / Week
BlockRec.zip 2020-01-27 41.4 kB
0
Readme.txt 2020-01-23 2.4 kB
0
Totals: 2 Items   43.8 kB 0 
/*********************************************************/
/***              STRYK System Improvement             ***/
/***    Performance Optimization & Troubleshooting     ***/
/***   GNU General Public License (V3, 29 June 2007)   ***/
/***                   www.stryk.info                  ***/
/*********************************************************/

# # #  B L O C K   R E C  # # #
 
Some features to automatically record blocks

PREFACE:

	<<For a moment, nothing happened. Then, after a second or so, nothing continued to happen.>> (Douglas Adams)
	
	"Blocked" queries are most annoying in SQL Server; stalling, delaying or even cancelling transactions.
	To thoroughly investigate and analyze these conflicts it is necessary to automatically record these issues.
	That's what this stuff is about ...

CONTENT:

	1_BlockRecording_Table.sql
	2_1_BlockRecording_Query.sql
	2_2_BlockRecording_INSERT_Query.sql
	3_BlockRecording_Job.sql
	4_BlockRecording_Alert.sql
	5_BlockRecording_Analysis.sql
	gpl-3.0.txt

REQUIREMENTS:

	Microsoft SQL Server 2005 - 2017 [2019]

	Permissions:
	User must be member of SQL Database-Role "sysadmin"

LICENSE:

	Published under GNU General Public License (V3, 29 June 2007)
	"gpl-3.0.txt"
	https://www.gnu.org/

DISCLAIMER:

	USE AS IS, AT OWN RISK, NO WARRANTY, NO GUARANTEE, NO SUPPORT

INSTALLATION:

	Extract "BlockRec.zip" to any folder and open the scripts in SQL Server Management Studio.
	The scripts will install a table [ssi_BlockRecording] into [msdb] and an Alert and Job [SSI: Block Recording]
	Basically the recorder-table could be installed anywhere, change at the relevant places in the templates.
	
	To install the auto-block-recorder you need to execute these scripts in given order:

	1	Create recorder TABLE	[ssi_BlockRecording]	
	3	Create recorder JOB		[SSI: Block Recording]
	4	Create recorder ALERT	[SSI: Block Recording]
	
	Done. The scripts 2_1 and 2_2 are only needed for testing purposes.
	
	With script 5 the recorded data could be analyzed.

DESCRIPTION:



	ERRORS AND OMISSIONS EXCEPTED

----------------------------------------------------------------------------------------------------

VERSIONS:

	1.0.0	Jan 2020	Jörg Stryk

----------------------------------------------------------------------------------------------------
EOF
Source: Readme.txt, updated 2020-01-23