Hi there everyone,
After upgrading our client from 260 SQL to 370 SQL, and changing the server to RAID 5 the performance dropped dramatically, especially in terms of disk reads. We weren't sure what the problem was and tried in vain to fix it.
After a bit of screwing around we discovered that going to File, Database, Alter, Options Tab and turning off "Allow Find as you Type", the Disk Queue length dropped astronomically! Since then, the performance of the database has been much much better.
So if you have a client with Disk I/O performance problems with Navision SQL, please turn off "Allow Find as you Type" and see if that helps!