NAV 400 SP2 and SQL Server 2005 SP1 issues?

GoMaD

Does anybody know of issues of SQL Server 2005 with Service Pack 1 and NAV 4.00 SP2?

Since the installation of the SP1 of SQL Server the db responds very slow. Reboot doesn't help and "warming up" the sql server takes ages (+- 5 minutes per key).

DB is 45 GB in size

Any ideas?

JohnnyRosenlund

We have the same problems. Very slow performance while expanding table views in general. Have tried to change "SourceTablePlacement" from default "Saved" to "First" as mentioned in performance guide, but that didn't solve our problem.

Please help...

theredmiata

All,

We have been testing Nav 4.0 SP1 against SQL 2005 SP1 and have come across this issue as well. Testing adjust cost yielded poor results - below the current level from our SQL 2000 SP4 configuration. The two changes below had dramatic improvements:

1) SQL 2005 Compatibility is enabled for your Navision database - Right, properties on your Navision db, Options, Compatibility Level

2) Network packet size is set appropriately compared to your network switches

Run the follow SQL against the master db

SELECT * FROM sys.configurations
ORDER BY configurgation_id ;
GO

Look for configurgation_id 505 network packet size. Ours is set as follows:

Value = 8192
Minimum = 512
Maximum = 32767

The original Values was 512.

We ran adjust cost against a network sniffer against SQL 2000 & 2005 and the 2k5 capture showed twice as many packets being sent vs 2k. We then inspected that the network interface card and switch port any anamolies (sp) and did not find any. Research thru the 2k5 BOL showed that you can only tune certain 2k5 parameters thru SQL statements and not thru the GUI. Give this a try...

Good Luck,

IMD in San Diego