Move non-clustered indexes
Published Feb 6, 2010 17:42 | Lars Westman
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...
Filed under:
Missing indexes in SQL
Published Jan 18, 2010 22:21 | Lars Westman
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...
Filed under:
NAV Performance - Application Settings
Published Jan 14, 2010 20:33 | Lars Westman
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...
Filed under:
NAV Performance - Key Groups
Published Jan 12, 2010 8:42 | Lars Westman
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. Therefore index...
Filed under:
Installing NAS on Windows 2008
Published Jan 11, 2010 14:00 | Lars Westman
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...
Hello World!
Published Jan 11, 2010 0:41 | Lars Westman
I finally got to the point where I felt it's about time to give something back to the community again... After a couple of Years of lurking around at blogs and forums (and there's ton's of great information out there, thank You all!) I started this blog to share thoughts, ideas and hopefully...