Have performance/locking problems with NAV on SQL - look here
Few new articles about NAV on SQL released by experts:
Lars Lohndorf-Larsen article "Record-level locking in the SQL Server option for Microsoft Dynamics NAV"
Waldo BLOG "What impact does my C/AL have on SQL?"
And look to Jörg A. Stryk homepage for ideas and help.