Posted inDynamics NAV & BC Tips & tricks

SQL Server Worker Threads and Microsoft Dynamics NAV

Microsoft Dynamics NAV has been configured to use the Microsoft SQL Server database engine as efficiently as possible. This includes using SQL queries which are appropriate for parallel query execution to speed up the retrieval of data when the SQL Server is configured to allow this. Parallelism in SQL Server can be controlled using the “max degree of parallelism” (aka MAXDOP) configuration option as explained in this article:

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…

Gerelateerde artikelen:

  1. Microsoft Dynamics NAV : Installing Dynamics NAV – Installing a SIDE database server
  2. How to Backup and Restore NAV Database Using SQL Server
  3. Microsoft Dynamics NAV : Installing Dynamics NAV – Preparing a Microsoft SQL Server database for Dynamics NAV installation
  4. Microsoft Dynamics NAV How To: Add A User To NAV 2013 Using Microsoft SQL Server
  5. Best practices for installing and configuring Microsoft SQL Server for Microsoft Dynamics NAV
Tags: