Can i view per Database memory usage on SQL Server? I have a test server with a number of databases on, which is filling with memory
i would like to analyse which databases are claiming the memory, is this possible?
Just be aware that the suggested queries focuses on the Buffer Pool (cached data).
A database can have other types of memory usage as well, like exec plans (when database bound), working memory for queries, locks, etc. I don't know of a way to summarize those since many are, sort of indirect consequences of doing things inside a SQL Server, and some are not necessarily bound to a certain database.