A dashboard from DMVs can show live requests, database state, waits, and backups when its queries refresh without adding load.
Low Memory Signals in the Resource Monitor Ring Buffer
Read the resource monitor ring buffer alongside Windows and process memory signals to investigate cache shrinkage in SQL Server.