MS-SQL Server - These Hail from RAM & SAN

These Hail from RAM & SAN

The selective DMVs and counters belong to physical memory.

Performance Counters
- Memory Grants Pending
- Total vs Target Memory
- Buffer Cache Hit Ratio
- Memory Broker Clerks

DBCC MemoryStatus
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/dbcc-memorystatus-monitor-memory-usage

SYS.dm_os_sys_memory
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-sys-memory-transact-sql?view=sql-server-ver16

SYS.dm_db_xtp_table_memory_stats
https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/monitor-and-troubleshoot-memory-usage?view=sql-server-ver16

SYS.dm_os_memory_clerks
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-memory-clerks-transact-sql?view=sql-server-ver16

SYS.dm_exec_query_memory_grants
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-memory-grants-transact-sql?view=sql-server-ver16

SQL SERVER DATABASE WITH SAN STORAGE
https://learn.microsoft.com/en-us/answers/questions/742789/sql-server-database-with-san-storage

Any query will be considered.

T. Amit Vaid S.