-
Hi all, I've noted that in version 2009 and 2009 SP1 when you create a new database on SQL server the default value for record set parameter is set on 50 and not 500 as was before. As far as I know that parameter decides in which case cursors must be activated, so in NAV 2009 every FINDSET instruction...
-
If you disable the "MaintainSQLIndex"-Option for any key in table of dynamics nav 2009, save the object and then try to enable the key again, there is a sql-error that you are not allowed to drop this index. The bug is independent from user rights in sql server. Does anybody know this bug or...
-
HI Jörg, Thank you. The nav_install.chm help file helps me a lot. And the web site link is very worthful. I have installed both SQL Server 2008 and Navision Sever successfully. Now Other SQL Classic clients can connect the SQL Server Db successfully. Please share some knowledge on the topic below...
-
Hi folks, well, I'm somewhat confused. As you might know, with 5.0SP1 MS has introduced several "enhancements" regarding NAV/SQL performance. Just to name some: VSIFT Cursor Preparation Buffered Inserts Changed Cursor types etc. Some/Most/Any (?) of those features is supposed to be in NAV...
-
Hi all, I've noted that in version 2009 and 2009 SP1 when you create a new database on SQL server the default value for record set parameter is set on 50 and not 500 as was before. As far as I know that parameter decides in which case cursors must be activated, so in NAV 2009 every FINDSET instruction...
-
If you disable the "MaintainSQLIndex"-Option for any key in table of dynamics nav 2009, save the object and then try to enable the key again, there is a sql-error that you are not allowed to drop this index. The bug is independent from user rights in sql server. Does anybody know this bug or...
-
HI Jörg, Thank you. The nav_install.chm help file helps me a lot. And the web site link is very worthful. I have installed both SQL Server 2008 and Navision Sever successfully. Now Other SQL Classic clients can connect the SQL Server Db successfully. Please share some knowledge on the topic below...
-
Hi folks, well, I'm somewhat confused. As you might know, with 5.0SP1 MS has introduced several "enhancements" regarding NAV/SQL performance. Just to name some: VSIFT Cursor Preparation Buffered Inserts Changed Cursor types etc. Some/Most/Any (?) of those features is supposed to be in NAV...
-
The company I work for is currently going through a NAV 2009 implementation. We've decided on the RTC client as we are going to have somewhere between 100-200 users on the system and believe that it will provide us a better user experience in the long run. We've not yet been able to find acceptable...
Posted to
Dynamics NAV / Navision - Microsoft SQL Server Forum
(Forum)
by
Shawn Kelly
on
Dec 17, 2009
Filed under: Maintenance Plans, Performance, SQL Server 2005, Optimization, SQL Server, Backup, NAV 2009, Dynamics NAV, Navision, SQL Server 2005 SP3, Database Environment, Navision 2009, SQL Performance
-
Can anyone recommend a hardware sizing for a server to host sql 2008 db for nav2009 implentation of about 100 users. Looking for some good solid specs around number of cores, memory, and storage configuration. Thanks.