SQL Server Stream Sizing

Scenario

Capturing and manipulating data does itself require disk storage. Sometimes it is useful to know how much space the system is using and how fast that usage is growing.

Where PhixFlow is running on top of a SQLServer installation, set up a PhixFlow Model to analyse the current PhixFlow instance, to determine and detail how much disk space is being used.

Solution:

• Create Streams to extract data from the internal PhixFlow tables.
• For each table that is part of a PhixFlow model, query sqlserver for its data size / disk requirements. Use the built in SQL Server stored procedure : sp_spaceused.
• As an additional exercise, determine the number of records, the number of streams and the archive details for each stream