You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Forms - Volume Management Total Storage Used not accurate?

Forms
Updated January 11, 2024
posted on January 9, 2024

The Volume Management is showing a total storage of 13.49GB and if you add up the individual processes this is what you get as well. However the SQL Express edition of Laserfiche is capped at 10GB and if we use SQL Studio to look at the database directly it shows 9.5GB. How can this be accurate?

0 0
replied on January 10, 2024

Hi Chad,

 

The "Total Storage Used" shows on Forms Volume is calculate based on the actual size of the attachments, not their size in SQL server.

This SQL Server uses its own compression algorithm to compress the data. The compressed data is stored in fewer pages, which can result in a smaller file size. You might want to check Data compression - SQL Server | Microsoft Learn for more information.

 

Thanks

0 0
replied on January 11, 2024

It is odd to see the uncompressed size for end users of the software. There are 2 versions of Laserfiche. One is the MS SQL Express edition which only works with a SQL Express backend and the other is the MS SQL Edition which works with non-Express SQL backends.

The big difference is how much storage you have in Forms. The MS SQL Express edition has a maximum storage of 10GB (Maybe it is 11GB now?) and the MS SQL Edition has unlimited storage.

When a customer is seeing they get close to their maximum data storage they can either decrease retention or setup a disk to store the attachments on (assuming the problem is with attachments). But it helps to clearly see how much of your available storage you have in the software front end, rather than having to go under the hood and look at the gas tank if you know what I mean.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...