Posted inDynamics NAV & BC Tips & tricks
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,…