Getting information about named caches

You can see information about caches by entering:

sp_cacheconfig
go

Cache Name          Status          Type  Config Value   Run Value
------------------ ------ -------------- ------------ ------------
default data cache Active Global,Default   0.00 Mb         8.00 Mb
------------ ------------       Total      0.00 Mb         8.00 Mb
========================================================================
Cache: default data cache, Status: Active, Type: Global,Default
	Config Size: 0.00 Mb, Run Size: 8.00 Mb
	Config Replacement: strict LRU, Run Replacement: strict LRU
	Config Partition: 1, Run Partition: 1
IO Size    Wash Size       Config Size     Run Size      APF Percent-------- ------------- ------------ ------------ -----------
2 Kb        1638 Kb         0.00 Mb         8.00 Mb           10
(return status = 0)