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
Last activity: Jun 25, 2022, 01:57 PM