Where is the SQL Server Memory Manager collection located?
说明
Where are the Memory Manager metric collection frequencies located for SQL Server agents?
原因
The Memory Manager collection has been merged into the SQL Server Host Group collection.
解决办法
To adjust the collection for the Memory Manager
Navigate to Databases
Enable the checkbox for the SQL Server database agent(s) and click the Administer Agents button or select Settings | Administration from the Database Dashboard.
Select Collection Frequencies
Highlight SQL Server Host Group and click the Edit button
Adjust the collection frequencies or disable/enable the collection
Click the Save Changes button
Restart the database agent for the new collection frequency to come into effect.
