General downloads
NAV $ndo$dbconfig updater
- Author
- Robert de Bath
- Category
- General downloads
- Date
- 03/02/2009
- Size
- 22,26 KB
- Downloads
-
1052
Detailed statistics
- Downloads today 0
- 30 day downloads 8
- Total downloads 1052
- Overall download rank #1259 / 2082
- Today page views 1
- 30 days page views 1
- Total views 3906
- Popularity
- Downloaded 4 times in the last two weeks
These objects allow simple configuration of the NAV V4 and V5
$ndo$dcconfig table from within NAV.
This table is used to tune the SQL statements sent to the SQL-2005 database engine. With the release of SQL-2005 Microsoft have added new optimisation options that the databse engine may choose when compiling an SQL statement. Unfortunatly while these optimisations can give good results on simple databases the combination of the extra optimisation and the caching of the compilied versions of the sql statments is very likely to cause very poor performance with large databses in NAV.
Because of this the NAV group within Microsoft have added the ability to tweak the statments generated by NAV to add the 'workaround options' that the SQL group have specified so that the performance avilable from SQL-2000 can be recovered or improved on.
The way these options are specified is through adding rather complex text strings to the table $ndo$dbconfig, this table is not normally available within NAV and so is not saved in an fbk backup. These objects make the table available within NAV and break up the specification so that it's a lot easier to remember how to use it.
Note the attached image shows a suggested starting setup for NAV V5, the Recompile option is not available for NAV V4. Also for these options to work properly you will need either NAV V4 sp3 Update 6 or NAV V5 SP1 running on SQL 2005 at least SP2 plus the updates to bring it to version 9.0.3152 or MS-SQL 2005 SP3.
This table is used to tune the SQL statements sent to the SQL-2005 database engine. With the release of SQL-2005 Microsoft have added new optimisation options that the databse engine may choose when compiling an SQL statement. Unfortunatly while these optimisations can give good results on simple databases the combination of the extra optimisation and the caching of the compilied versions of the sql statments is very likely to cause very poor performance with large databses in NAV.
Because of this the NAV group within Microsoft have added the ability to tweak the statments generated by NAV to add the 'workaround options' that the SQL group have specified so that the performance avilable from SQL-2000 can be recovered or improved on.
The way these options are specified is through adding rather complex text strings to the table $ndo$dbconfig, this table is not normally available within NAV and so is not saved in an fbk backup. These objects make the table available within NAV and break up the specification so that it's a lot easier to remember how to use it.
Note the attached image shows a suggested starting setup for NAV V5, the Recompile option is not available for NAV V4. Also for these options to work properly you will need either NAV V4 sp3 Update 6 or NAV V5 SP1 running on SQL 2005 at least SP2 plus the updates to bring it to version 9.0.3152 or MS-SQL 2005 SP3.