on 04-03-2017 8:23 PM - last edited on 02-03-2024 9:37 PM by postmig_api_4
Default data cache Size is only 25 GB.
But monCachedObject showing -2271 GB
sp_cacheconfig
go
Cache Name Status Type Config Value Run Value
---------------------- -------- -------- -------------- ------------
dbcc cache Active Mixed 2000.00 Mb 2000.00 Mb
default data cache Active Default 25000.00 Mb 25000.00 Mb
reference_tables_cache Active Mixed 25600.00 Mb 25600.00 Mb
tempdb_cache Active Mixed 6500.00 Mb 6500.00 Mb
select CacheName, sum(TotalSizeKB*1.0)/1024/1024
from monCachedObject
group by CacheName
CacheName
------------------------------ ---------------------------------------------------------------
tempdb_cache 0.39362907409667968750000
reference_tables_cache 21.29217720031738281250000
default data cache 2271.58776092529296875000000
dbcc cache 0.39142799377441406250000
TotalSizeKB -- is the total size of table . not cach size .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.