My team (no DBAs in the team) is responsible for a database hosted on an SQL server with multiple other databases used by other areas of the business. Memory usage has recently been spiking to 100% on the server, causing performance issues for all the applications making use of this common database server.
We do not think our database is responsible for the spikes, but I lack the knowledge to prove it. Is there any way to check memory usage by database to identify the culprit?
What I tried:
Microsoft support provides queries to see memory usage by memory-optimized objects, but following these steps show that we have no 0 MB. perhaps our database does not use memory-optimized objects? https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/monitor-and-troubleshoot-memory-usage?view=sql-server-ver16
This page describes how to see memory usage at the server-level, but it does not help me to determine which database is utilizing the memory. https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver16
Any pointers would be helpful, even if they are just questions I should direct to our IT group.