web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Re-indexing while runn...
Microsoft Dynamics AX (Archived)

Re-indexing while running batch jobs

(0) ShareShare
ReportReport
Posted on by Tung Duong 242

Hi all,

We are having a problem with the system performance. We usually have to run large amount of transactions via batch jobs, like everyday. To improve the performance, we are planning to run re-index regularly, but we are not sure if there could be any problem happens with the batch job while we are re-indexing. Are those transactions being posted via batch jobs cancelled after we run the re-index?

Anyone can suggest us with this problem? Thanks in advance,

Regards.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    You're swinging a big hammer to hit what could be a small nail.

    Are you certain that the performance issues are rooted in SQL Server?  If so, perhaps you just need a new index, or need to update statistics, or need to identify a handful of queries that need some attention.  Re-indexing regularly accomplishes almost nothing for performance.  What it manages to do is clear your cache plans, and since that helps sometimes but not always, that tells me it's far more likely that statistics are an issue.

    Try updating statistics with fullscan across all of your tables.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    I would suggest you schedule the re-indexing during non-business hours and out of the schedule of batch jobs. During re-indexing the tables will be locked for any transaction.

    So AX will not be able to process any request against that table.

    Also, check if you have a RAID 5 config in your storage? This could seriously affect your data writing speeds. RAID 10 is the best option you could have for AX database storage.

  • Martin Dráb Profile Picture
    Martin Dráb 237,807 Most Valuable Professional on at

    The exact answer depends on quite a few things you didn't mention, such as us which action are you preforming (index reorganization / rebuild) and whether you have Enterprise Edition of SQL Server. In general, it can be done relatively safely (although it may have impact on performance), nevertheless make sure that your reindexing scripts do run reindexing only if needed (such as if index fragmentation is too high). Transactions being posted via batch jobs definitely won't be cancelled.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans