The V8 Search XE SQL Toolbox is divided into two areas; the first area contains queries relating to the SQL Server. The second section is again divided into two parts. The first section deals with the selected database and general questions about the status of the SQL database. In the second section, the queries are specifically geared towards the topic of database indexing.<\/p>\n
\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-01.png\")
\n<\/div>\n\n
SQL Server Check<\/h6>\n
The SQL Server Check section had a complex substructure with a myriad of SQL scripts that can document the state of the SQL server. You will not need every script every day, some of them may never be executed. Of course, we cannot judge how your SQL server landscape is structured. The included scripts offer you the possibility to react to different scenarios.<\/p>\n
\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-02.png\")
\n<\/div>\n\n
In jedem einzelnen Themenordner im SQL Server Check stehen ihnen diverse Abfragen zur Verf\u00fcgung.<\/p>\n
\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-03.png\")
\n<\/div>\n\n
SQL Server Database<\/h6>\n
The SQL Server Database area is divided into two categories. The first part relates to information about the status of the SQL database. The second category, SQL Server Database Index, is specifically focused on the performance and the associated indexing of the database. An optimal SQL database index strategy for Dynamics Business Central is extremely important. From our point of view, every system administrator should deal intensively with this topic. For example, when a Business Central page is opened or filtered for data in a page, Business Central sends a query to the SQL server to retrieve the data. If this query does not have an optimal index, the display of the data in the page is very often delayed. In the worst case, slow queries without an optimized index lead to table locks or deadlocks. We therefore believe that indexing Business Central SQL databases is extremely important. Every system administrator should deal intensively with this topic.<\/p>\n
\n
To use the SQL Server database queries, first select the SQL database about which you want to obtain information.<\/p>\n
\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-04.png\")
\n<\/div>\n\n
The name of the individual queries in the SQL toolbox indicates the content of the information. <\/p>\n
\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-05-1024x782.png\")
\n<\/div>\n\n
Unfortunately, we cannot go into every single query in this article, as the collection in the SQL Toolbox is extensive. <\/p>\n
Im zweiten Teil des Artikels pr\u00e4sentieren wir ihnen detaillierte Details zu den einzelnen Abfragen und zeigen ihnen, wie Sie mit den gewonnenen Erkenntnissen umgehen k\u00f6nnen.
\n <\/p>\n
![\"V8](\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8-Search-XE-SQL-Toolbox-06-1024x888.png\")
\n<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n