Database list not being displayed when Memory Resource is selected
No Memory waits in the given time period, thus, there are databases being displayed.
If there are only waits for CPU Usage, Network Wait, and Log Wait, these are the ONLY 3 that will have any Databases listed. The other metrics will not display the database list.
Moreover, the memory graph has two possible explanations.
1. The user may be using the AWE mechanism to allocate memory to SQL Server. This is an issue where Performance Analysis reports AWE memory as non-SQL memory.
2. The other possibility is that the SQL Server really isn't doing anything, so it's not using much memory. Based on the screenshots from the Memory Wait question attached, it would appear the instance is relatively inactive.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center