We are implementing Nav 5 sp1 with SQL 2005 sp3 (64 bit). The server has 10G of ram and has no load on. It has a couple of users at best and even with no users its still slow.
It has been a clean install with the platform 1 update KB956161 applied.
I'm creating a Sales order and when I type in the customer number, their is a delay of 3 seconds to populate the address delays and other fields on the Sales Order Header.
There are only 250 customers, a handfull of sales orders.
Even getting the sales order number generated is a couple of seconds delay.
The same slowness is apparent for a Purchase order. Their is a delay of a couple of seconds for a the PO number and about 3-4 second delay after the vendor number is entered. (there are only 1500 vendors).
SQL has Raid 10 volumne for the TransLog and tempdb and Raid 1 volumne for the data. The database is less than 1.5Gb
I want to get the sale order entry to be faster... 'almost instant' response.
How do I make Nav 'fly' on SQL?
Where do I start looking to find the bottle neck?
I know this is a $64 question, but if someone can point me to a guide to locate the problem?