1) System Configuration
SELECT *
FROM sys.configurations
ORDER BY name OPTION (RECOMPILE);
2) Filename and Paths of Database
SELECT DB_NAME([database_id])AS [DBName],
name, physical_name, type_desc, state_desc,
CONVERT( bigint, size/128.0) [SizeinMB]
FROM sys.master_files
ORDER BY DB_NAME([database_id])
3)OS level information
SELECT *
FROM sys.dm_os_sys_info
