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) / Move DOCUVALUE table t...
Microsoft Dynamics AX (Archived)

Move DOCUVALUE table to a different filegroup

(0) ShareShare
ReportReport
Posted on by arey 369

Hi,

We want to store documents in AX Database but we are wondering if could be better to move DOCUVALUE table to a different filegroup in a new disk in order to avoid performance and space issues.

Anyone has tried? Any considerations we should take into account?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Container and Image fields in AX are stored in Large Binary Objects (LOB data) which is not easy to relocate.

    I have found this script to be very useful when we have decided to split up our database across multiple files and filegroups:

    sql10.blogspot.hu/.../easily-move-sql-tables-between.html

    Initially we have separated LOB data to a different LOB filegroup, but then we have finally decided to distribute evenly instead across the multiple file groups together with the main data. The design is up to you depending on the number of IO paths you are able to grant for each database file/disk. In our case the underlying disk solution was similar to the Azure BLOB-storage, so it is on a block level and IO paths are not relevant, so for us keeping it all together and just logically separating the files for parallel CPU calls seemed more logical. If you are more like in a SAN-situation, splitting it out could work for you, however test it thoroughly first.

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    If the answers above have resolved your issue, take your time to tick the checkbox next to the helpful posts to close the topic.

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