The Database Files module collects database file information from managed servers. This gives you a record of all databases files – and their settings and sizes – for the entire enterprise, and allows you to track files as they come and go, grow, and shrink.

Tables

Collector.DBFileProperties

Stores the collections of database file data.

Definitions for the many of the Collector.DBProperties columns can be found in the following MSDN articles:  
Column Type Description
ID bigint Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers.
DBName varchar Database name.
FileGroup varchar See the DataFile MSDN article (Parent property).
FileName sysname See the DataFile MSDN article.
UsedSpaceKB bigint See the DataFile MSDN article.
AvailableSpaceKB bigint See the DataFile MSDN article.
FullFileName nvarchar See the DataFile MSDN article.
type tinyint See the sys.database_files MSDN article.
type_desc nvarchar See the sys.database_files MSDN article.
file_id Int See the sys.database_files MSDN article.
file_guid uniqueidentifier See the sys.database_files MSDN article.
data_space_id int See the sys.database_files MSDN article.
state tinyint See the sys.database_files MSDN article.
state_desc nvarchar See the sys.database_files MSDN article.
SizeKB int See the sys.database_files MSDN article.
max_sizeByte int See the sys.database_files MSDN article.
growth int See the sys.database_files MSDN article.
is_media_read_only bit See the sys.database_files MSDN article.
is_read_only bit See the sys.database_files MSDN article.
is_sparse bit See the sys.database_files MSDN article.
is_percent_growth bit See the sys.database_files MSDN article.
is_name_reserved bit See the sys.database_files MSDN article.
create_lsn numeric See the sys.database_files MSDN article.
drop_lsn numeric See the sys.database_files MSDN article.
read_only_lsn numeric See the sys.database_files MSDN article.
read_write_lsn numeric See the sys.database_files MSDN article.
differential_base_lsn numeric See the sys.database_files MSDN article.
differential_base_guid uniqueidentifier See the sys.database_files MSDN article.
differential_base_time datetime See the sys.database_files MSDN article.
redo_start_lsn numeric See the sys.database_files MSDN article.
redo_start_fork_guid uniqueidentifier See the sys.database_files MSDN article.
redo_target_lsn numeric See the sys.database_files MSDN article.
redo_target_fork_guid uniqueidentifier See the sys.database_files MSDN article.
backup_lsn numeric See the sys.database_files MSDN article.
sample_ms int See the sys.dm_io_virtual_file_stats MSDN article.
num_of_reads bigint See the sys.dm_io_virtual_file_stats MSDN article.
num_of_bytes_read bigint See the sys.dm_io_virtual_file_stats MSDN article.
io_stall_read_ms bigint See the sys.dm_io_virtual_file_stats MSDN article.
num_of_writes bigint See the sys.dm_io_virtual_file_stats MSDN article.
num_of_bytes_written bigint See the sys.dm_io_virtual_file_stats MSDN article.
io_stall_write_ms bigint See the sys.dm_io_virtual_file_stats MSDN article.
io_stall bigint See the sys.dm_io_virtual_file_stats MSDN article.
size_on_disk_bytes Bigint See the sys.dm_io_virtual_file_stats MSDN article.
file_handle varbinary See the sys.dm_io_virtual_file_stats MSDN article.
io_stall_queued_read_ms bigint See the sys.dm_io_virtual_file_stats MSDN article.
io_stall_queued_write_ms bigint See the sys.dm_io_virtual_file_stats MSDN article.
VolumeFreeSpaceByte bigint See the DataFile MSDN article.
 

dbo.DBFilePropertiesConfig

Under development.
 

Stored procedures

Collector.spDBFilePropertiesInsert

This procedure performs the insert into the Collector.DBFileProperties table.

DBFileDataPropertiesGET.exe and DBFileLogPropertiesGET.exe call this procedure to insert data into the Collector.DBFileProperties table.

Important: This procedure is meant to be used by automated collectors; we recommend against using it manually. Therefore, the parameter set is only documented internally.
 

Views

Collector. DBFilePropertiesCurrent

Provides the most recent collection of database file data.
Each “Current” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Descr
 

Collector.DBFilePropertiesPrevious

Provides the next-to-latest collection of database file data.
Each “Previous” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Descr
 

Jobs

CollectorDBFileDataPropertiesGet-GOLD

Calls the executable DBFileDataPropertiesGET.exe for all servers with ServiceLevel = ‘Gold’, to retrieve database file information.
 

CollectorDBFileDataPropertiesGet-SILVER

Calls the executable DBFileDataPropertiesGET.exe for all servers with ServiceLevel = ‘Silver’, to retrieve database file information.
 

CollectorDBFileDataPropertiesGet-BRONZE

Calls the executable DBFileDataPropertiesGET.exe for all servers with ServiceLevel = ‘Bronze’, to retrieve database file information.
 

Executables

DBFilePropertiesGet.exe

Perform the data file collection for the servers in the specified service level. Log the results to Collector.DBFileProperties.

NOTE: In a future release of Minion Enterprise, the Database Files module will allow you to centrally set database file properties from a single place.  For example, you will be able to standardize growth rates across all databases on all instances.  What’s more, the Database Files process will monitor the settings you configure, to ensure that they are not changed. 

Parameters:

  • $Query – This parameter refers to the service level that the collector should operate on. Examples: Gold, Silver, Bronze. For more information on this topic, see the article “Executables and Service Levels”.
  • $FileType – This allows you to filter the type of files to retrieve data for. By default, $FileType = All.  Other valid values include: Data, Log.

Example execution:
C:\MinionByMidnightDBA\Collector\InstanceConfigPUSDBFilePropertiesGet.exe Gold All


 
https://minionware.desk.com/customer/portal/articles/2378847-database-files-module
http://www.MinionWare.net