Skip to main content

Microsoft Dynamics NAV 2017 - SQL Database Locks.

Hi Readers,

Yes, you read the title correctly it says, Database Locks. There are some pretty cool changes in terms of Identifying Locks that may occur during our code execution in Microsoft Dynamics NAV 2017.

After Release of Microsoft Dynamics NAV 2013, we were unable to identify that from Dynamics NAV it was so hard to figure out the Lock details via SQL Server.

For Already Published Articles about NAV 2017, Click Here.

Below are the details of Enhancements for Monitoring SQL Database Lock in Microsoft Dynamics NAV 2017.




1. Microsoft Dynamics NAV Debugger Shows us the Duration of the Code That is executing. 

Put some breakpoint, Run the debugger, start the Code Processing and Navigate to Debugger when system waits for action at a breakpoint.
Now we can see the time duration that code took to execute till the breakpoint.


2. Microsoft Dynamics NAV 2017 can show the Current Locks in Database if there are any.

In an Event of Lock, select Tools - Debugger - Database Lock as shown below.


System will show you details about Lock which will include -

  1. Table Name - Specifies the name of the Dynamics NAV table affected by the lock.
  2. SQL Lock Resource Type - Specifies the database resource affected by the lock,such as DATABASE, FILE, OBJECT, PAGE, KEY, and more.
  3. SQL Lock Request Mode - Specifies the lock mode that determines how concurrent transactions can access the resource.
  4. SQL Lock Request Status -
    1. CNVRT - The lock is transitioning from another mode, but the conversion is blocked by another process that holds a lock with a conflicting mode.
    2. GRANT - The lock is active.
    3. WAIT - The lock is blocked by another process that holds a lock with a conflicting mode.
  5. The user who is causing the Lock (not the user who is running Navision Service).
  6. Object Type. 
  7. Object ID.
  8. Function Name.

The feature is enabled for the demo database from Microsoft. 
In the Next article, we will discuss how we can enable this feature for a customer database.

What do you feel about this new feature? Waiting for your comments. 
If you want a demo of the Locking to see how it works, do let me know.

Regards,
Saurav Dhyani

Comments

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.