MB of buffer cache dedicated to each database. This will rise and fall as SQL Server manages the memory pages relative to workload in each database. Large, rapid changes in one database that appear to affect other databases (one trace rises while another falls at the same collection time) are worth investigating to ensure your systems are not fighting for physical resources.<\/p>\r\n\r\n
Check the results of this and resolve the issues:<\/p>\r\n\r\n
SELECT [sp].[name] AS [server principle] ,\r\n [sp].[default_database_name] ,\r\n [sp].[principal_id] ,\r\n [sp].[sid] ,\r\n [sp].[type] ,\r\n [sp].[type_desc] ,\r\n [sp].[is_disabled]\r\nFROM [sys].[server_principals] AS sp\r\n INNER JOIN sys.databases AS d ON [sp].[default_database_name] = d.[name]\r\nWHERE [d].[state_desc] <> 'online'\r\nORDER BY [sp].[default_database_name] ,\r\n [sp].[name];<\/pre>","tsql":"SELECT (COUNT(*) * 8.0) \/ 1024 AS MB\r\n FROM sys.dm_os_buffer_descriptors AS dobd\r\n WHERE [dobd].[database_id] = DB_ID();\r\n","instances":true,"frequency":300,"databases":{"mode":0},"rateofchange":false,"metricenabled":true,"noalertremark":"An alert is not required","alertdescription":"","aboveorbelow":"above","collections":1,"alertenabled":false,"_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"frequency_comment":"Every 5 minutes, unless you want to investigate in more detail.","targetentitytype":0}