Welcome to MSDN Blogs Sign in | Join | Help

February 2008 - Posts

Tuesday, February 26, 2008 9:29 AM

Index Usage Query

This is a follow up from an earlier blog "Finding Index usage" . In that blog, I described a very simple way to list how indexes are being used. In this blog, the query is much extended so that it now shows your Navision keys, listed by either number
Posted by Lohndorf | 4 Comments
Filed under:
Wednesday, February 20, 2008 11:49 AM

How to detect locking order for a NAV process

The nature of a deadlock is that two processes lock resources in different orders. Deadlocks can in theory be eliminated by ensuring that all processes always lock resources in the same order. This document describes how to determine the locking order
Posted by Lohndorf | 0 Comments
Filed under:
Wednesday, February 06, 2008 8:16 AM

Record-level locking in the SQL Server option for Microsoft Dynamics NAV

If you are designing a system for high throughput and want to minimize blocking, it's important to know in advance exactly what kind of locking behaviour to expect. On SQL Server, Microsoft Dynamics NAV uses record-level locking, as opposed to table-level
Posted by Lohndorf | 5 Comments
Filed under:
 
Page view tracker