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.
Some significant changes have been introduced to the internal database structure for Microsoft Dynamics NAV 2013 R2 in order to support the powerful new Multitenancy functionality. These changes impact on how the NAV application manages a collation change whether or not you are using Multitenancy.
When running a report from the Windows Client with Microsoft Dynamics NAV 2013 R2, filter values specified on the request page are saved along with the relevant user’s personalization information. These filter values are conveniently restored to the request page the next time the user runs the same report.
