cancel
Showing results for 
Search instead for 
Did you mean: 

monCachedObject -- showing incorrect value

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

TotalSizeKB -- is the total size of table . not cach size .