DCS 6.7 database structure is now optimised and filesystem is different from previous version
The install/upgrade creates 733 partition files per event table (cspevent, analysis_event, profile_event). This means there will be a total of 2199 files created. These files are created upfront at install/upgrade time. These files are required to handle the purge process. Auto growth is required on these files, but will only start growing once a file (which contains each day’s worth of events) fills up and needs additional space to handle more volume of events.
Partitioning makes large tables or indexes more manageable, because partitioning enables you to manage and access subsets of data quickly and efficiently, while maintaining the integrity of a data collection.
See the list of files created in attachment to this doc.