Video Center - Performance Optimization for Dynamics NAV / 365 Business Central and SQL Server
Introduction to the video learning series Performance Optimization with V8 Search XE.
V8 Search XE is the new analytics software to solve the challenges of the modern Dynamics NAV / 365 BC and SQL Server professional.
While you can read all about the new features of V8 Search XE in our documentation , you can also learn from videos. And who better to tell you about the V8 Search XE tool than the Dynamicsproject team that created the product. We are pleased to introduce our new Video Learning Series on Performance Optimization with V8 Search XE, taught by all members of the V8 Search XE engineering
Gain new skills and learn the benefits of Video Center - Performance Optimization for Dynamics NAV / 365 Business Central and SQL Server with detailed guides. Start your journey today and explore our learning paths and modules.
V8 Learn is just the start.
Start with the basics, then move on to advanced methods that address real-world challenges. V8 Learn picks you up where you are and takes you to your destination.
Learn important concepts - at your own pace and according to your schedule. Whether you have 5 minutes or an hour, we enable you to gain practical skills through video tutorials.
Video 01 (German)
In this tutorial we will examine SQL queries with long durations coming from a Dynamics NAV server...
Video 02 (German)
In this video we would like to take a closer look at the TSQL Editor of V8 Search XE with its functions and possibilities.
Use the TSQL Editor to analyze scripts with Transact-SQL statements.
Video 03 (German)
In this video I explain what the Navigation Explorer in V8 Search XE is. The Navigation pane provides functionality for managing "meta data objects" of a Dynamics NAV or Dynamics 365 Business Central database in instances of SQL Servers.
Metadata is object definitions in XML format, "User Code" is application code written in C# .Net format and stored as "User AL code". This code can be edited in the C/AL editor
(Object Designer of the development environment) for Dynamics NAV and Visual Studio Code for Dynamics AL to be written and compiled.
The functionality shown here is hugely important when searching the entire Dynamics object system for terms in all imported objects. V8 Search XE is the analysis tool to optimize performance problems in Dynamics NAV or Dynamics 365 Business Central.
Video 04 (German)
Identify table locks in Dynamics NAV above Dynamics 365 Business Central.
The database lock controls simultaneous access to the same data by multiple users. To protect a transaction against other transactions that modify the same data, the first transaction locks the data. The lock remains in place until the transaction is completed.
Users can be locked out of completing transactions with the locked data.
You will usually receive a message indicating the lock status:"The transaction could not be completed because a record in the '...' table was locked by another user."
. Event tracking in V8 Search XE provides detailed information about what is occurring on the Microsoft Dynamics NAV server when users are working with Microsoft Dynamics NAV / 365 BC, resulting in blocking or deadlocks.
Watch this video to learn more about methods and capabilities of V8 Search XE to Identify table locks in Dynamics NAV or 365 Business Central.
Say hello to the future.
Each month a new topic will be available on our YouTube- channel on the topic Performance Optimization for Dynamics NAV / 365 Business Central and SQL Server. Watch a video topic that interests you.
We hope you have as much fun learning and watching these videos as our team has. Welcome to V8 Search XE!
Good luck on your performance tuning journey!
Your Dynamicsproject.com Team