Plaza 365
Plaza 365

No results found for your search

RegisterLog in

0

Rebuild your index on MsDyn365FO Tier1 and Tier2+ environments

Visit article

#database

#index

#sqlservermanagementstudio

#storedprocedures

#tier2+

Dynamics 365 Finance

Category

Dec 21, 2022

Published date

Text

Article Type

AI Summary

  • The article discusses the recent updates to the Microsoft Dynamics 365 for Finance and Operations database, which include new stored procedures for rebuilding indexes.
  • These stored procedures can be used on both Tier1 and Tier2+ environments, such as before starting a load test run.
  • The article mentions that the Data Administration and Management Service (DAMS) should take care of indexes on Tier2+ environments, but the stored procedures provide an alternative option for those who do not trust DAMS.
  • The specific stored procedure mentioned in the article is called AXPerf_IndexMaintenance and can be started in SQL Server Management Studio.
  • The article provides an example command for starting the AXPerf_IndexMaintenance stored procedure, including various parameters such as MAXDURATION, TOPLIMITOFINDEXES, ONLINEDEFRAG, MAXDOP, and SCHEMA.
  • The MAXDURATION parameter determines the maximum duration of the index maintenance in minutes.
  • The TOPLIMITOFINDEXES parameter specifies how many indexes should be considered in the current maintenance run.
  • The ONLINEDEFRAG parameter can be set to 1 to run online defragmentation/rebuild, and the MAXDOP parameter determines the maximum degree of parallelism.
  • The SCHEMA parameter specifies the schema for which the maintenance should be run.This is the complete content of the article.

Registered users can view the full text for FREE!

Sign In Now!