Share
ReportMy database is getting too slow, and i want to optimize it using SHIFT Optimization. Please someone post how to perform SHIFT Optimization.
*This post is locked for comments
You’re offline. This is a read only version of the page.
145
My database is getting too slow, and i want to optimize it using SHIFT Optimization. Please someone post how to perform SHIFT Optimization.
*This post is locked for comments
Hi,
from NAV 5.0 SP1 SIFT Tables are indexed views , from NAV 2009 optimized with the introduction of the RoleTailored architecture.
An indexed view is similar to a SQL Server view except that the contents have been materialized (computed and stored) to speed up the retrieval of data.
Because is an "SQL Server Object", you can optimize Indexed Views using sql agent and a scheduled maintenance plan (scheduiling reorganixe tables, defrag or rebuild indexes and Indexed views)
The NAV Optimization told (look at Naville Post) is similar to SQL Rebuild (drop & recreate indexes, you can select some table, indexes views etc.) but is obsolete from NAV 2009 & NAV 2013,
my suggest is: on NAV 5.0 Sp1 or greaters use SQL Server optimization insteaf of NAV Optimization.
Some NAV 2009 links:
SIFT and Microsoft Dynamics NAV with Microsoft SQL Server
msdn.microsoft.com/.../dd355336.aspx
Tuning and Tracing
using SQL Profiler to tracing Sift performance
msdn.microsoft.com/.../dd301142.aspx
SIFT and Performance
Hi Jagesh
Not sure what you mean by SHIFT optimization, could you perhaps mean SIFT optimization?
SIFT optimization was a lot more relevant with the non SQL version of the database, you will get a lot more performance from other areas such as SQL optimizations and looking at possibly more SQL memory, faster HDD's setups in the server
If you want to run the optimizations however it may slightly improve performance however i suspect this change may be so small as to be unnoticeable
Open the classic NAV client, with the database opened click on "File" -> "Database" -> "Information"
On the screen that opens click the tables button at the bottom
Select a range of tables and hit the optimize button,
Be aware that this may take a long time to run on big tables so you can do ranges of small tables but only a single table whee there are a lot of records
Hope this helps
Cheers
Nev
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
