Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Expense attachments causing database growth

  1. Last updated
  2. Save as PDF

Symptoms
When Changepoint put expense receipt attachment into standard product, the attachments are stored in the same database where the application data is stored. The upshot of that is tremendous growth in the database since that change was implemented, which we believe is negatively affecting performance and causing an issue with simply allocating space.

 

 

Resolution
Changepoint has number of filegroups to split up tables and objects into different database files (mdf, ndf).

ExpenseAttachment table belongs in a separate filegroup called “Changepoint4” and does not reside with primary filegroup. Typical filename for this filegroup is [Changepoint]_3.ndf. This filegroup also contains KBAttachment and KMAttachment tables.

Customer can configure the database to have this ndf file reside on another drive, separate from the primary database file ([Changepoint].mdf) if they wish.