Using SQL Server Extended Events to produce a Blocked Process Report

Blocking in SQL Server is a mixed blessing! It is a SQL Server’s way of ensuring data integrity which is a basic requirement for any database management system but when users encounter a lot of blocking it makes the application appear slow and sometimes unusable. Therefore, system administrators need to be able to analyse SQL Server blocking and take action to minimise it in order to get the best database performance possible.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply