{"id":5091,"date":"2018-03-07T11:58:40","date_gmt":"2018-03-07T09:58:40","guid":{"rendered":"https:\/\/www.dynamicsproject.com\/?page_id=5091"},"modified":"2024-04-05T12:15:44","modified_gmt":"2024-04-05T10:15:44","slug":"v8-search-xe","status":"publish","type":"page","link":"https:\/\/www.dynamicsproject.com\/en\/v8-search-xe","title":{"rendered":"V8 SEARCH XE"},"content":{"rendered":"


\n\"\"<\/p>\n

\n

If you decide that a professional monitoring \/ analysis solution is right for you, Dynamicsproject.com can support you with V8 Search XE. V8 Search XE is a .Net analysis solution for performance monitoring of your SQL Server and Dynamics 365 Business Central \/ NAV solution.<\/p>\n

\n

<\/p>\n

\n
\n
\n <\/p>\n
\n
\n <\/i><\/p>\n
\n
We provide answers<\/a><\/h5>\n

You will finally be able to answer the question: \"Which Dynamics NAV \/ BC user locks the table!\" <\/strong><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n
\n <\/i><\/p>\n
\n
Effective analysis<\/a><\/h5>\n

You have countless possibilities to analyse the performance of your SQL Server and Dynamics NAV \/ 365 BC code.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n
\n <\/i><\/p>\n
Simple, Fast and Fun<\/a><\/h5>\n

Monitoring, diagnosis and optimization of SQL Servers \/ Dynamics C\/AL operations with V8 Search XE.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/section><\/div>\n

<\/p>\n

\n

\n

V8 Search XE | Using the V8 Search XE diagnostic tools and the new V8 XE Profiler, you can easily view the execution history of your Dynamics NAV C\/AL programming and the resulting SQL Server TSQL transaction in a live streaming view.<\/p>\n

\n

The V8 Perf Analyzer is a feature of <\/span>V8 Search XE<\/a>that provides a live display window with extended events that show table locking and deadlocks in Business Central \/ NAV.
\n Use the comprehensive Vision 8 profiler tool without the debugger to gain far-reaching insights into the performance of your Dynamics 365 Business Central \/ NAV solution, including CPU, GPU and memory utilisation and SQL Server network usage.<\/p>\n

\n

 Profiling and diagnostics.<\/h5>\n

Quickly find bugs in your Dynamics NAV solution and non-optimal configurations of SQL Server. While your NAV enterprise solution is live, you can retrieve information that will help you identify performance issues with your application.<\/p>\n

\n

 Why should you use the new V8 XE Profiler?<\/h5>\n

\n

Unlike the SQL Profiler, the V8 Perf Analyzer is directly integrated into V8 Search XE and is based on the scalable technology for extended events in the SQL module of the SQL Server.
\n This new feature in V8 Search XE provides quick access to a live streaming view for diagnostic events such as table locking or deadlocks in SQL Server caused by Dynamics NAV. V8 Search XE is the evolution of V8 Monitor. The session created by the V8 Perf Analyzer interferes with SQL Server execution to a lesser extent than a similar SQL trace created using the SQL Profiler.<\/p>\n

\n

 Understanding and solving blocking issues SQL Server and Dynamics NAV\/D365BC<\/h5>\n

\n

The Microsoft Dynamics NAV Server manages communication between Microsoft Dynamics NAV clients and Microsoft Dynamics NAV databases in SQL Server. The NAV Server uses an ADO.NET interface, which is a managed data access layer that supports SQL Server connection pooling. Each connection is displayed as a session ID (SPID). Each of these SPIDs is often referred to as a process but not a separate process context in the usual sense. Instead, each SPID consists of server resources and data structures of requests required by a single connection of a particular client. A Dynamics NAV client may have one or more connections to the NAV server. From SQL Server's perspective, there is no difference between a single Dynamics NAV client to a single computer and multiple connections from multiple Dynamics NAV clients or multiple client computers. One connection can block another connection, regardless of whether they originate from the same application or separate programs on two different client computers.
\n The problem - which Windows user has which connection (SPID), as the management of three-tier Microsoft Dynamics NAV architecture is used. That is, there is always NAV Server connected to SQL Server and thus the Windows user of the NAV service application is always displayed.<\/p>\n

\n

Viewing Lock Information in SQL Server (Database Module) with V8 XE Profiler<\/p>\n

\n

V8 XE Profiler provides several ways to retrieve information about current lock activity in an instance of SQL Server Database Engine (database module) and the Dynamics NAV clients.<\/p>\n

\n

This overview describes the reasons for using this V8 XE Profiler, its main features, and how to get started viewing advanced events.<\/p>\n

\n
\n

\n

1. open SQL transactions <\/p>\n

\n<\/p><\/div>\n

\n

You can use the \" Open SQL transactions\" to get information about the current lock status in a SPID.<\/p>\n

\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n

\n
\n

\n

2. Blocking <\/p>\n

\n<\/p><\/div>\n

\n

Determine which queries contain locks.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n
\n

\n

3. Deadlocks<\/p>\n

\n<\/p><\/div>\n

\n

Deadlocks occur when multiple tasks permanently block each other because each of the tasks maintains a lock on a resource that the other tasks are trying to lock. <\/p>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n

\n
\n

\n

4. Long Duration<\/p>\n

\n<\/p><\/div>\n

\n

SQL queries (Very slow - take several minutes instead of fractions of a second).<\/p>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n

\n
\n

\n

5. NAV Windows User Name (SPID)* <\/p>\n

\n<\/p><\/div>\n

\n

Since Dynamics NAV 2013 there is a function to display C\/AL call stacks for SQL commands. Here you can see, for example, which user uses which SPID at which time.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n

\n
\n

\n

6. Full SQL Trace** <\/p>\n

\n<\/p><\/div>\n

\n

When you enable SQL trace, SQL Server events are captured for selected sessions on the Microsoft Dynamics NAV Server instance.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n

<\/p>\n

\n

*V8 Windows Service<\/h2>\n

\n Each Microsoft Dynamics NAV Server Instance in use requires a V8 Windows Service to monitor deadlocks, SPIDs and which queries contain locks on the SQL Server. With the V8 services Dynamics NAV C\/AL functions and SQL statements can be displayed simultaneously.\n <\/p>\n<\/p><\/div>\n

 <\/p>\n

V8 Search XE Whitepaper<\/h3>\n

 
\n This white paper (the whitepaper is in German) describes functionality and system requirement for V8 Search XE.<\/p>\n

 
\n V8 Search XE Whitepaper (DE)
\n Download<\/a>
\n  
\n  
\n V8 Search XE Whitepaper (EN)
\n Download<\/a>
\n  
\n <\/p>\n

\n

System requirements<\/h3>\n

 
\n Unterst\u00fctzte Dynamics NAV Versionen (On Premise)<\/strong><\/p>\n

    \n
  • NAV 2015..2018<\/li>\n<\/ul>\n

    Unterst\u00fctzte Dynamics Business Central Versionen (On Premise)<\/strong><\/p>\n

      \n
    • Business Central 12..23<\/li>\n<\/ul>\n

       
      \n Required Dynamics NAV \/ Business Central licenses C\/AL (C\/SIDE Application Language)<\/strong><\/p>\n

        \n
      • Application Builder<\/li>\n
      • or<\/li>\n
      • Solution Developer<\/li>\n<\/ul>\n

         <\/p>\n

        Operating systems supported<\/strong><\/p>\n

          \n
        • Windows Server 2022 (x64)<\/li>\n
        • Windows Server 2019 (x64)<\/li>\n
        • Windows Server 2016 (x64)<\/li>\n
        • Windows 10 (x64)<\/li>\n
        • Windows 11 (x64)<\/li>\n<\/ul>\n

           <\/p>\n

          Unterst\u00fctzte Microsoft SQL Server<\/strong><\/p>\n

            \n
          • SQL Server 2014..2022<\/li>\n
          • —————<\/li>\n
          • Azure SQL Server<\/li>\n<\/ul>\n

             
            \n Software requirements<\/strong><\/p>\n

              \n
            • Microsoft .NET Framework 4.8 or higher<\/strong><\/li>\n
            • SQL Server Management Studio (SSMS – Version 19.2) oder h\u00f6her<\/strong><\/li>\n
            • SQL Server 2019 Express with Advanced Services or higher<\/strong><\/li>\n
            • Power BI Desktop (Optional)<\/strong><\/li>\n<\/ul>\n

               
              \n Hardware requirements<\/strong><\/p>\n

                \n
              • Processor with 2.8 GHz or faster<\/li>\n
              • at least 16 GB RAM <\/li>\n
              • min. 20 GB available hard disk space<\/li>\n<\/ul>\n

                 
                \n Required Dynamics NAV objects (must be provided by the user!)<\/strong><\/p>\n

                  \n
                • 1 Codeunit<\/li>\n<\/ul>\n

                   
                  \n Notes<\/strong><\/p>\n

                    \n
                  • Use an administrator account to install, uninstall and start V8 Search XE.<\/li>\n
                  • To start V8SEAXE as administrator, hold down the \"Ctrl\" and \"Shift\" keys and click on the respective program icon. The program will start in administrator mode.<\/li>\n<\/ul>\n

                     
                    \n V8 Search XE is only available in English language!<\/strong><\/p>\n

                    \n

                    Get to know V8 Search XE in a personal online demonstration.<\/p>\n

                    \n

                     
                    \n
                    \n
                    \n <\/p>","protected":false},"excerpt":{"rendered":"

                    Wenn Sie sich dazu entscheiden, dass eine professionelle Monitoring \/ Analyse L\u00f6sung f\u00fcr Sie das Richtige ist, kann Dynamicsproject.com Sie mit V8 Search XE unterst\u00fctzen. V8 Search XE ist eine.Net Analyse L\u00f6sung zur Performance \u00dcberwachung Ihres SQL Servers und der Dynamics 365 Business Central \/ NAV L\u00f6sung. Wir liefern Antworten Sie werden endlich die Frage […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"fullwidth.php","meta":{"footnotes":""},"class_list":["post-5091","page","type-page","status-publish","hentry"],"yoast_head":"\nV8 SEARCH XE - Dynamicsproject.com<\/title>\n<meta name=\"description\" content=\"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicsproject.com\/en\/v8-search-xe\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"V8 SEARCH XE - Dynamicsproject.com\" \/>\n<meta property=\"og:description\" content=\"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicsproject.com\/en\/v8-search-xe\" \/>\n<meta property=\"og:site_name\" content=\"Dynamicsproject.com\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-05T10:15:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2022\/06\/Front-Search-XE.png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe\",\"name\":\"V8 SEARCH XE - Dynamicsproject.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Front-Search-XE.png\",\"datePublished\":\"2018-03-07T09:58:40+00:00\",\"dateModified\":\"2024-04-05T10:15:44+00:00\",\"description\":\"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\\\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Front-Search-XE.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/Front-Search-XE.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/v8-search-xe#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"V8 SEARCH XE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\",\"name\":\"Dynamicsproject.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicsproject.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#organization\",\"name\":\"Dynamicsproject.com\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/DPLogo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/DPLogo.jpg\",\"width\":350,\"height\":53,\"caption\":\"Dynamicsproject.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"V8 SEARCH XE - Dynamicsproject.com","description":"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicsproject.com\/en\/v8-search-xe","og_locale":"en_US","og_type":"article","og_title":"V8 SEARCH XE - Dynamicsproject.com","og_description":"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.","og_url":"https:\/\/www.dynamicsproject.com\/en\/v8-search-xe","og_site_name":"Dynamicsproject.com","article_modified_time":"2024-04-05T10:15:44+00:00","og_image":[{"url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2022\/06\/Front-Search-XE.png","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe","url":"https:\/\/www.dynamicsproject.com\/v8-search-xe","name":"V8 SEARCH XE - Dynamicsproject.com","isPartOf":{"@id":"https:\/\/www.dynamicsproject.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe#primaryimage"},"image":{"@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2022\/06\/Front-Search-XE.png","datePublished":"2018-03-07T09:58:40+00:00","dateModified":"2024-04-05T10:15:44+00:00","description":"V8 Search XE | Mithilfe der V8 Search XE - Diagnosetools und dem neuen V8 XE Profiler k\u00f6nnen Sie den Verlauf der Ausf\u00fchrung Ihres Dynamics NAV C\/AL Programmierung und die daraus resultierenden TSQL Transaktion des SQL Servers einfach in einer Livestreamingansicht anzeigen.","breadcrumb":{"@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicsproject.com\/v8-search-xe"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe#primaryimage","url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2022\/06\/Front-Search-XE.png","contentUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2022\/06\/Front-Search-XE.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicsproject.com\/v8-search-xe#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.dynamicsproject.com\/"},{"@type":"ListItem","position":2,"name":"V8 SEARCH XE"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicsproject.com\/#website","url":"https:\/\/www.dynamicsproject.com\/","name":"Dynamicsproject.com","description":"","publisher":{"@id":"https:\/\/www.dynamicsproject.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicsproject.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dynamicsproject.com\/#organization","name":"Dynamicsproject.com","url":"https:\/\/www.dynamicsproject.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2015\/05\/DPLogo.jpg","contentUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2015\/05\/DPLogo.jpg","width":350,"height":53,"caption":"Dynamicsproject.com"},"image":{"@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/pages\/5091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/comments?post=5091"}],"version-history":[{"count":184,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/pages\/5091\/revisions"}],"predecessor-version":[{"id":10313,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/pages\/5091\/revisions\/10313"}],"wp:attachment":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/media?parent=5091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}