-
After upgrading a 3.7 - to 5.0 I have a performance issue during restore on SQL. After upgrade a restore to a navtive db takes 6 min. When I do the same on my SQL server - the restore takes 4 hours! This is a db with 110 companies, but not very many transactions in each. Next weekend I will do the same...
-
After upgrading a 3.7 - to 5.0 I have a performance issue during restore on SQL. After upgrade a restore to a navtive db takes 6 min. When I do the same on my SQL server - the restore takes 4 hours! This is a db with 110 companies, but not very many transactions in each. Next weekend I will do the same...
-
We have implemented Navision in several sites and are beginning to see performance issues each of these sites. All sites are running SQL server 2005, and windows 2003. Hardware is as per the HW guide and if anything we have future proved by over specing the HW. Transactions are roughly in the vicinty...
-
Hi, We made a move from SQL2000 to SQL2005 and an upgrade from NAV 3.7 to NAV 5.0. We installed a new server with SQL2005 and NAV 5.0. I have made a backup in NAV 3.7 (.fbk) and restored this file in an empty database NAV 5.0 (be sure the codeset of the database is the similar to the old one). Afterwards...
-
[quote user="p_d2k"]You mean I should isolate the SQLServer and install NAVISION Server seperately on another box and have users having NAVISION Client to this NAVISION Server which in turn would communicate with the SQLServer. That means a good change in the Architecture....hmmmm[/quote] Not...
-
I do seem to have the numbers mixed up. The way it was explained to me is that the most performant and fault tolerant RAID array is where you stripe mirrored sets. I was told that it is faster AND it is more fault tolerant. If you lose one disk in a striped array, you lose the whole array, so losing...
-
Hi David, But it seems NAVISION 4.0 with SP1 cannot be run in 3 tier way. Then how do I implement 3 tier architechture using the same. I want to have a seperate SQL Database Server, an NAV Client Server to which the users wud connect to access the SQL Database Server. Its not possible to migrate to NAV...
-
[quote user="p_d2k"]Thanx again Jorg...I hope Microsoft is watching this... You mean I should isolate the SQLServer and install NAVISION Server seperately on another box and have users having NAVISION Client to this NAVISION Server which in turn would communicate with the SQLServer. That means...
-
Thanx again Jorg...I hope Microsoft is watching this... You mean I should isolate the SQLServer and install NAVISION Server seperately on another box and have users having NAVISION Client to this NAVISION Server which in turn would communicate with the SQLServer. That means a good change in the Architecture...
-
[quote]Is there any other way that I can run the cost batch on a different server and then merge it with the existing one.[/quote] I'm afraid, this is not easily possible. I've seen solutions, which have modified the costing batches to be split in "chunks", so that they could process...