...
Where PhixFlow is running on a SQLServer SQL Server installation, set up a PhixFlow Model to analyse the current PhixFlow instance, to determine and detail how much disk space is being used.
...
- Create Streams to extract data from the internal PhixFlow tables.
- For each table that is part of a PhixFlow model, query sqlserver SQL Server 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
...
- Create Streams to extract data from the internal PhixFlow tables.
- For each table that is part of a PhixFlow model, query the meta data metadata table for its field types, and data size / disk requirements.
- In the case of varchar fields, take a statistically significent ramdom significant random sample of actual data record fields to determine the average length of varchars stored.
- As an additional exercise, determine the number of records, the number of streams and the archive details for each stream.