How to check amount of data on Dap Server.

Objective:

I want to see how much data is on my Dap server.

Resolution:

There are two methods to check this:

First method: use Windows File Explorer to browse to ...\[DAPDataFolder]\Storage. 

• Display the properties of the Storage folder to view the sizes of all files in the folder/subfolders.
• Note, that the total volume will include cache files and a list of configuration files.   Users must have at least read permissions to the Storage folder to use this method.

Second method: to use SQL scripts.

• Users must have sufficient permission to access their DAPcatalog database. The script returns the total volume of datasets that are successfully published. Run the script from SQL Server Management Studio.
  
  SELECT SUM(Size)/1024.0/1024.0/1024.0  AS [Volume(GB)]
  FROM Dataset d
  JOIN DatasetInformation di ON di.DatasetId = d.Id
  WHERE d.StatusId = 3

If you encounter any issues with the workflow above, please contact Seequent at [e-mail].