Raw data folder continues to grow in size for SQL Server PI repository (4228871)

The short term and long term SQL PI data disk storage areas are separate on the SQL Server instance host used by the SQL Server PI repository.

The long term data disk space is not used while the short term data disk space continues to grow in size.

Please run the following SQL in the SQL PI repository (the database name to be changed to the appropriate name) using SQL Server Management Studio (SSMS) to get the file size information:

USE [PI_DATABASE] 
GO

SELECT DB_NAME() AS DbName, 
name AS FileName, 
physical_name AS PhysicalName,size/128.0 AS CurrentSizeMB, 
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB 
FROM sys.database_files; 

Confirm if the long term data is located on the correct drive. If it is not and the repository is using the short term data disk, then either

• Drop the long data disk and assign that space capacity to the short data disk.

or

• Move the long data database file from the short data disk to the long data disk.