Folder SQL Server Database

Last updated 02 March 2021.

 SQL Server Database - Performance troubleshooting and profiling for Dynamics NAV | BC and SQL Server

Checks SQL Server in scope for some of most common skewed Best Practices and performance issues.
Valid from SQL Server 2012 onwards. By default all databases in the SQL Server instance are eligible for the several database specific checks, and you may use the optional parameter to narrow these checks to specific databases.





 Contains the following informational sections:


In the SQL database section there are now some queries that you can filter on special table names. When you start the query and a dialog box with the "SpecifiedTable" parameters appears, you can enter the table name or leave the parameter value empty. If you confirm with okay and have inserted a table name, the SQL query will be executed specifically on this table. If you leave the parameter value blank, the SQL query will be executed for the entire database.

The filtering applies to the following SQL queries:

  • SQL Server Database -> Automatic Statistics Updating
  • SQL Server Database -> Buffer Usage
  • SQL Server Database -> Last time table was accessed
  • SQL Server Database -> Objekt modify

 

 General
Version
Automatic Statistics Updating 2.0
Query Execution Counts 2.0
Future Plans 2.0
Recent Full Backups 2.0
Buffer Usage 2.0
IO Stats By File 2.0
Last Update Object 2.0
Information Object 2.0
Table Stats 2.0
Database Size History 2.0
Available Space in MB 2.0
Check Statistics 2.0
Find Queries using the index in Query Store 2016 2.0
Find tables with similar table structure 2.0
Last time table was accessed 2.0
Objekt modify 2.0
Parameter Stored Procedure 2.0
Search for Queries in the Execution Plan Cache 2.0
Search the Execution Plan Cache for Index Hints 2.0
Search the Exec Plan Cache for Index Hints 2016 2.0

V8 Search XE. Designed and built by Olav Treffurt IT Consulting. Copyright © 2021 DynamicsProject.com. All rights reserved.

Trademarks
Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, Dynamics 365 Business Central, Windows, Windows Server, and the other products listed on the trademarks page of the Microsoft website are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.