There are loads of documents covering SQL setup and performance and if you have just moved the database from Navision native to SQL then it is probable that you are going to have to do quite a few changes on Indexes and SIFTS in Navision as well as SQL maintenance and of course the Hardware. I strongly recommend reading some of these documents first:
- Tuning Navision for better performance, Revision 5, Created May 21, 2004
- Microsoft Dynamics™ NAV 4.0, Hardware Guide, White Paper
- Installation & System Management: Microsoft® Business Solutions–Navision®,SQL Server Option
Nic
PS: 4gb RAM would be much better