Диагностика SQL Server одной страницей: службы, шифрование и файлы БД

от 
SELECT
    servicename,
    service_account
FROM sys.dm_server_services;

SELECT
    servicename,
    instant_file_initialization_enabled
FROM sys.dm_server_services;

SELECT
    db_name(database_id) AS database_name,
    encryption_state
FROM sys.dm_database_encryption_keys;

SELECT
    DB_NAME(database_id) AS DBName,
    name,
    type_desc,
    size * 8 / 1024 AS SizeMB,
    growth,
    is_percent_growth
FROM sys.master_files
ORDER BY DBName, type_desc;

#mssql