Hi guys, Great News! NAV 2018 will be released !
“NAV 2018 will be released late…, will become generally available later this calendar year !”
…after a bit of confused news about the existence of NAV 2018 (… and the continuation of the name “Dynamics NAV” in favor of the “Tenerife” name only…) finally yesterday the arcane was unveiled directly from a Microsoft post .
Take a look to this post from Alysa Taylor (General Manager of Global Marketing for the Cloud & Enterprise Business Applications and Industry division):
Simplifying Dynamics 365 offerings https://community.dynamics.com/b/msftdynamicsblog/archive/2017/09/22/simplifying-dynamics-365-offerings
Alysa: “For small businesses who prefer to install their business management solution on-premises, we will continue to offer Dynamics NAV, Dynamics GP, and Dynamics SL. Dynamics NAV 2018 and Dynamics GP 2018 will become generally available later this calendar year. We’re committed to continuing the innovation we will bring in Dynamics 365 for our customers and partners, enabling them to accelerate business transformation, regardless of customer size and business complexity.”
…was therefore correct the name presented in session topics (NAV 2018) the day before the keynote #1 @directions us… NAV 2018 is real!
my old post about directions us https://robertostefanettinavblog.com/2017/09/16/nav-2018-some-news/
Stay tuned .. once again !
SQL Monitor
I’ve done a lot of NAV optimizations and sometimes it’s enough to isolate the bigger issues to get a good result. Since NAV 2015 and with latest releases of NAV you can use standard monitoring systems… take a look to my old post about NAV 2015 Performance Counters: Monitoring Microsoft Dynamics NAV 2015 Server Using “Performance Counters”
https://robertostefanettinavblog.com/2015/07/06/monitoring-microsoft-dynamics-nav-2015-server-using-performance-counters/
BUT
If you are using old versions of NAV (.. and older versions of SQL Server sure), you must use the NAV Client Monitor tool or directly detect SQL Server performance indicators, for example monitoring SQL Server, active sessions, poor query, locks, extra NAV db user activities etc. etc.. The best solution is to collect traffic information over time (execution snapshots) so you can identify critical processes. By reading this data, you can propose a good tuning solution.
SQL Monitor is a nice and free solution to detect bottlenecks.
You can download from Technet – https://gallery.technet.microsoft.com/scriptcenter/SQL-Monitor-a845753d
Microsoft Best Practices about Monitoring and Tuning
“The goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends.
Monitoring SQL Server lets you do the following:
· Determine whether you can improve performance. For example, by monitoring the response times for frequently used queries, you can determine whether changes to the query or indexes on the tables are required.
· Evaluate user activity. For example, by monitoring users trying to connect to an instance of SQL Server, you can determine whether security is set up adequately and test applications or development systems. For example, by monitoring SQL queries as they are executed, you can determine whether they are written correctly and producing the expected results.
· Troubleshoot any problems or debug application components, such as stored procedures.”
BEST SQL SERVER PERFORMANCE INDICATORS
1. SQLServer: Memory Usage
2. SQLServer: Buffer Manager: Buffer cache hit ratio
3. SQLServer: General Statistics: User Connections
4. SQLServer: General Statistic: Processes
5. SQLServer: SQL Statistics: Batch Requests/Sec
6. SQLServer: Locks: Lock Waits / Sec: _Total
7. SQLServer: I/O Latch (Session Pending)
8. SQLServer: Disk I/O (datafiles pression rate)
MONITORING FAVORITE STEPS
To monitor any component of SQL Server effectively, follow these steps:
1. Determine your monitoring goals.
2. Identify components to monitor.
3. Select metrics for those components.
4. Monitor the server.
5. Analyze the data.
Query Monitoring
“Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. Consequently, it is essential to have access to detailed, real-time information on the performance of entire instances and databases, along with diagnostic tools to quickly locate and resolve specific performance issues.”
Some standard SQL Scripts
Ø Top 50 Query Execution
SELECT TOP 50 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1),
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
qs.last_elapsed_time/1000000 last_elapsed_time_in_S,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY qs.total_logical_reads DESC -- logical reads
NAV 2018 some news
“The Winter is Coming” … and NAV 2018 is coming… sure, I’m a fan of “Game of Thrones” … Emilia Clarke (Daenerys Targaryen) #1 , Directions US sessions is starting… and the new name of NAV is confirmed: “NAV 2018”
Sessions of the three next main events have been published; some of them in the future will be modified, integrated and enriched. However, it is already possible to begin to understand the new functionalities of NAV 2018 (the new name of product has been confirmed as can be seen in “What’s New” session of US Directions scheduled for 18-09).
Below is a list sessions from Directions US.
Directions US Sessions (17-20 September 2017)
http://www.directionsna.com/agenda/2017-sep-17/all-sessions/
NAV 2018 BEST SESSION’S TOPICS
Desktop and Web Client Enhancements
Improved App functionalities
Server and database improvements (.. a lot of features.. some under NDA)
Better Mobile Experience
Semplified CRM Area
Cognitive Services
Better Cortana Intelligence
Easy Deployment of NAV using Docker Windows Container
From rumours and not under NDA info:
Best Integrations with:
Excel (…you can edit G/L Entry in excel…. My good !!) using bidirectional integration
Power BI (…not only for role centers.. Power BI everywhere???)
Microsoft Flow and Bookings (workflow for ALL…)
Outlook and Linkedin integration (reminders and contact card..)
… and… Cognitive Services (AI- Artificial Intelligence), born with Azure cognitives services, in this case can be used by NAV to recognize images and save in right place (ad example for items and resources cards)
Improved OCR
NEXT EVENTS ABOUT NAV 2018 AND DYNAMICS BUSINESS EDITION (FOBE)
TOMORROW
Directions US Sessions (17-20 September 2017
COMING SOON
Directions EMEA Sessions (4-6 October 2017)
http://www.directionsemea.com/#schedule
THE LAST AND MOST FAMOUS
NAV Tech Days Sessions (14-17 November 2017)
https://www.navtechdays.com/2017/sessions
Have a nice NAV 2018 experience and waiting for my next post… “NAV 2018 What’s New”… after 18 September of course… i hope.
Attached a brief presentation about MRP and planning in Dynamics NAV. This document is a collection of information about the subject with many useful links, the sources come from MSDN, from some best blogs (my opinion) and from free documents available on Internet.
You can download it from slideshare, have a good read !
MRP and Planning Overview
“Nice to have” books for the new development environment
Hi, while we wait the transition of the new development environment from the preview mode to the final release, I summarize a list of usefull books to read about the topics related to it:
Visual Studio and ASP.NET
Docker
Powershell
Dynamics NAV
These topics are interesting for both NAV and Dynamics 365 Business Edition.
My old posts about new development environment
Vs Code Extensions
https://robertostefanettinavblog.com/2017/08/31/vs-code-al-extensions-part-i/
VS Code and Modern Development Environment Preview
https://robertostefanettinavblog.com/2017/08/28/updated-presentations/
“NICE TO HAVE” BOOKS
VISUAL STUDIO CODE
Visual Studio Code in a Day
Visual Studio Code Succinctly
https://www.syncfusion.com/resources/techportal/details/ebooks/Visual_Studio_Code_Succinctly
Visual Studio Code Tips & Tricks
http://aka.ms/ebook-VSCodeTipsTricks
VISUAL STUDIO AND ASP.NET
Building an ASP.NET Application in VS 2017
Mastering Visual Studio 2017
DOCKER
Learning Docker
Mastering Docker
POWERSHELL
Powershell Beginner’s guide
Mastering Powershell
DYNAMICS NAV
Programming Dynamics 5 – Fifth Edition
With NAV 2017 specifics
https://www.packtpub.com/books/content/introduction-nav-2017
Extending Dynamics NAV 2016 (this is a great book!!)
Mastering Dynamics NAV
Have a nice reading!