====== System profile ======
===== Basics =====
<code tsql>SELECT @@VERSION  -- includes edition string
EXEC xp_msver
</code>

===== Database files =====
<code tsql>
SELECT 
  db.database_id
, db.name AS DbName
, db.recovery_model_desc
, db.is_auto_shrink_on
, mf.name AS LogicalFileName 
, mf.type_desc
, mf.physical_name
, mf.size
, mf.growth
, mf.is_percent_growth
FROM sys.databases db
  INNER JOIN sys.master_files mf ON mf.database_id = db.database_id
ORDER BY
  db.name
, mf.file_id
</code>

===== Memory usage =====
From [[http://basitaalishan.com/2013/01/14/find-the-available-amount-of-memory-available-sql-server-instance-machine/]]:

<code tsql>-- To get the total physical memory installed on SQL Server
SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB]
    ,[available_page_file_kb] / 1024 AS [Available_Physical_Memory_In_MB]
    ,[total_page_file_kb] / 1024 AS [Total_Page_File_In_MB]
    ,[available_page_file_kb] / 1024 AS [Available_Page_File_MB]
    ,[kernel_paged_pool_kb] / 1024 AS [Kernel_Paged_Pool_MB]
    ,[kernel_nonpaged_pool_kb] / 1024 AS [Kernel_Nonpaged_Pool_MB]
    ,[system_memory_state_desc] AS [System_Memory_State_Desc]
FROM [master].[sys].[dm_os_sys_memory]
 
--To get the minimum and maximum size of memory configured for SQL Server.
SELECT [name] AS [Name]
    ,[configuration_id] AS [Number]
    ,[minimum] AS [Minimum]
    ,[maximum] AS [Maximum]
    ,[is_dynamic] AS [Dynamic]
    ,[is_advanced] AS [Advanced]
    ,[value] AS [ConfigValue]
    ,[value_in_use] AS [RunValue]
    ,[description] AS [Description]
FROM [master].[sys].[configurations]
WHERE NAME IN ('Min server memory (MB)', 'Max server memory (MB)')
</code>

{{tag> housekeeping disk memory configuration}}