Estimating diskspace utilization for databases and Analytics indexes

Published July 19, 2013

When working with Relativity workspaces, system admins are often asked to estimate the diskspace and the cost associated with a Relativity database and Analytics index. This recipe provides some workflows and associated scripts that can help you calculate this for your workspaces.

Requirements

  • Relativity 7.0 or above
  • Workspace with system admin-level access

Directions

The rule of thumb measurements and methods below help system admins estimate the size of their Relativity database and associated Analytics indexes.

It’s noteworthy that these metrics have a high standard deviation and tend to scale up or down linearly. Every data set is different, so please note that this is only an average. Files will vary in size considerably.

Workspace sizes

On average, every 100,000 records consume about 10 GB of database space. Database diskspace usage is roughly one third of the total file size, including natives and images, for a workspace.

In addition to the above approximation, system admins can execute the Billing Statistics – Case Roll-up script that is preinstalled in every Relativity environment. This script helps you calculate accurate numbers on the size of your SQL database and the size of the files associated with the workspace.

Note: This script can only be run in Home mode.

Analytics index sizes

With default Analytics profile settings for an Analytics index, disk space usage is approximately 20 percent of the size of the corresponding SQL database’s MDF file.

To get an accurate measurement, system admins can use the Relativity Analytics Billable Estimate script to determine the precise size of an Analytics index. This script runs on a workspace level against a saved search of documents submitted to the Analytics index.

References

Analytics