Skip to Content
0

monCachedObject -- showing incorrect value

Apr 03, 2017 at 07:23 PM

30

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Pandey Ajay Kumar Apr 03, 2017 at 07:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded