web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Move DOCUVALUE table to a different filegroup

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

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Move DOCUVALUE table to a different filegroup

    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.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans