My database is getting too slow, and i want to optimize it using SHIFT Optimization. Please someone post how to perform SHIFT Optimization.
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
Neville FoynNAV Developer, Consultant & Trainer (Since 2001)MCTS NAV, CRM, Sharepoint, SQLMCITP NAVMCT
Any possible way of scheduling the optimization process? Either NAV application services or SQL Agent?
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
Tuning and Tracing
using SQL Profiler to tracing Sift performance
SIFT and Performance
Best Regards, Roberto Stefanetti
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics