I had some serious issues with getting the 2015 Web client working on my dev machine where I also have 2013R2 Web client installed. The Application Pool kept stopping and error 503 was thrown. The solution was to change the identity on the Application Pool for the 2015 Web client from ApplicationPoolIdentity to NetworkService. After […]
Author Archive | Lars Westman
Binary Conversion
Here’s a piece of code if you want to convert to binary using C/AL Int2Bin(InStr : Text[50]) BinStr : Text[50] WHILE Quotient > 0 DO BEGIN i += 1; IF i MOD 8 = 1 THEN BinStr := PADSTR(”, 8, ’0’) + BinStr; //Insert 8 zeros for each new byte Remainder := Quotient MOD 2; […]
LogTrade Connect for Microsoft Dynamics NAV
Nu kan du enkelt koppla ihop NAV med LogTrade. Se mer på www.logtradeconnect.se
Upgrade NAV-runtime and enable Style Sheets
Lately there has been many upgrades of NAV-runtime since customers are upgrading their PC:s to Windows 7. There’s usually no big deal to upgrade only the run-time enviroment but keep in mind that it’s not supported by Microsoft if You should run into problems, so do Your testing before doing it on a production database. […]
Disable Parameter Sniffing in SQL2008
Microsoft has released Cumulative Update Package 7 for SQL2008 SP1 (KB797065). In this update there is a new feature (trace flag 4136) that let us control wether or not the Query Optimizer should do parameter sniffing (KB980653). You may remember all the debates on the forums about index hinting and parameter sniffing in NAV 4.0 […]
Move Your non-clustered indexes
When You create a NAV-database You end up with tables, clustered indexes and non-clustered indexes in the same filegroup. That’s not optimal from a performance perspective. You can gain performance by separating the actual data (tables/clustered indexes) from Your non-clustered indexes by moving these to a separate filegroup and a separate array of disks. If […]
Missing indexes
Index tuning in Dynamics NAV is often done by analyzing indexes and how they are used. There’s a nice tool from the MS NAV Team that You can run from inside NAV to analyze You existing indexes. But what if You are missing indexes and are facing read problems rather than problems write performance? Could I […]
How Application Setup can hurt performance in NAV
NAV Performance is often discussed in technical terms like index tuning and hardware sizing. I would like to share some thoughts on how settings in the application also side affect performance. I hope this post can be of interest for some non-technical people who is engaged in system setup. Performance as a shared responsibility in […]
Key Groups
One important area in performance tuning is the setup of keys and indexes. A key in NAV is by default maintaned as an index in SQL Server Index Tuning Indexes help the user to get data out of the database fast, but needs to be updated as soon as data is changed which cost performance. […]
Installing NAS on Windows 2008
User Account Control in Windows 2008 surely has it’s benefits. But it really has some down sides also. When You install the Application Server (NAS) on a w2k8 logged in as a user which is local admin (but not logged in as administrator) everything looks just just fine. The install finishes with no errors. The […]