Folder SQL Server Database Index

Last updated 02 March 2021.

 SQL Server Database Index - 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:

Under the menu item "SQL Database" -> "SQL Server Database Index" the function "Index breakdown" has been changed. The function no longer analyzes the entire database but only a specially specified table.For the parameter "ReportStyle" please enter the value 0 or 1.

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 Index -> Simple Redundant Index Query
  • SQL Server Database Index -> Volatile Indexes
  • SQL Server Database Index -> Which Index Is Never Used
  • SQL Server Database Index -> Overall Index Usage Reads
  • SQL Server Database Index -> Index Fragmentation
  • SQL Server Database Index -> Get Fill Factor for all Indexes on Database
  • SQL Server Database Index -> Find Statistics Information
  • SQL Server Database Index -> Fixing SQL Server Fragmentation
  • SQL Server Database Index -> Indexes Script Out

 

 General
Version
Simple Redundant Index Query 2.0
Volatile Indexes 2.0
Which Index Is Never Used 2.0
Overall Index Usage Reads 2.0
Duplicate Indexes 2.0
Index Fragmentation 2.0
Get Fill Factor for all Indexes on Database 2.0
Most Important Miss Indexes 2.0
Script out all Indexes in a Database 2.0
Missing Indexes 2.0
Find Statistics Information 2.0
Fixing SQL Server Fragmentation 2.0
Index breakdown 2.0
Indexes Script Out 2.0
Indexes Information current DB 2.0
Indexes Information do not check Primary Keys 2.0
Indexes Information Non Custered Indexes 2.0
Indexes Information Specified Index 2.0
Indexes Information Specified Table 2.0
User Table Heap 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.