Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

cache memory in dmv?

sys.dm_os_sys_info holds the physical memory info. Is there any DMV that holds the cache memory in the SQL server?

thanks
ASKER CERTIFIED SOLUTION
Avatar of Dimitris
Dimitris
Flag of Greece image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna
anushahanna
Flag of United States of America image

ASKER

Thanks a lot for the useful query. I ran that and got this:

total_sql_server_memory_kb      6GB
buffer_cache_kb      NULL
procedure_cache_kb      NULL
buffer_cache_used_kb      NULL
procedure_cache_used_kb      8
total_cache_used_kb      NULL
percent_procedure_cache_used      NULL
percent_buffer_cache_used  NULL

counter_name      cntr_value 2432
Granted Workspace Memory (KB) 0
Lock Memory (KB)    1208
Optimizer Memory (KB) 752
SQL Cache Memory (KB) 3.5MB

For 6GB SQL memory, is 3.5MB Cache enough?