Memory usage SQL 2008/R2
Here are two ways to see which database is using a lot of memory on your SQL. Keep in mind that the task manager is only showing max. 4GB of memory even if you have like 8GB running. SELECT (CASE WHEN ([is_modified] = 1) THEN ‘Dirty’ ELSE ‘Clean’ END) AS ‘Page State’, (CASE WHEN ([database_id] […]
