Sample Header Ad - 728x90

Indexing operations on a 8TB AX dynamics database

0 votes
0 answers
53 views
We have an 8TB AX dynamics database on SQL Server 2016 Enterprise Edition. Our team would like to perform indexing operations but for a max of 8 hours with minimal impact during the week. My recommendation was to run online operations using Ola's script during the week and allow offline during weekend only. The feedback I got is that Ola's script creates a worktable (to do list of operations) at every invocation of the script, That is correct. They rather have a script that creates a worktable initially and only creates a new worktable when the previous one is completely handled, to avoid some indexes that are never touched. Is somebody aware of such a script?
Asked by TimBer (11 rep)
Jun 24, 2022, 02:40 PM
Last activity: Jun 25, 2022, 01:57 PM