-
[quote user="rseiber"]Aray 1 is raid 1 with 2 SAS 73GB 15K drives - OS - Win 2k3 SP2 32bit SQL 2k5 SP2 with logs on this drive[/quote] That might be one of your problems right there. With the logs on the most active drive array, it is wonder it is slowing down. It is recommended that the transaction...
-
Hi Because of the way navision locks tables it is very easy when everybody is doing simular things for the transactions to become serialised, that is they happen one after the other rather than them all happening at the same time and this is especailly true for table writes. So what happens is the first...
-
This is very typical for a NAV implementation on SQL Server. NAV uses a fat client which does all the processing. It sends out very simple queries to SQL with the result that CPU utilisation is zip compared to 'normal' SQL systems. Don't worry to much about it and try to focus on Disk I/O...
-
We are currently doing an upgrade from Nav 4.0 on SQL 2k to Nav 5 on SQL 2k5 SP2. We are currently in the testing phase of the upgrade and our server is crawling. server is a Dell poweredge 2950 with the following setup: 2 Intel Xenon X5355 Quad core processors Aray 1 is raid 1 with 2 SAS 73GB 15K drives...
-
Hi Many thanks for the response. Here is some data that you asked...if u need further clarifications, pls let me know Q. I need to know how many concurrent users are there? 90 Logins on an Avg....though the database is serializabily accessable (means no two users can modify a particular table...this...
-
[quote user="Mitesh"] Hi IHAC who has deployed Navision for Retail stores. The deployment architecture is described below: Intel Blade with 1 Xeon E5320 Quad Core 1.86 GHz 16 GB memory 4x 146GB SAS Drives The App sits on the C Drive of the Blade The DB sits on an external storage connected...
-
Hi IHAC who has deployed Navision for Retail stores. The deployment architecture is described below: Intel Blade with 1 Xeon E5320 Quad Core 1.86 GHz 16 GB memory 4x 146GB SAS Drives The App sits on the C Drive of the Blade The DB sits on an external storage connected via FC HBA The external storage...