Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rahul Singh Find memory used by particular Database RE: Find memory used by particular Database
The Wizard Of Oz
SSC Eights!
Points: 855
More actions
December 18, 2012 at 3:33 am
#1569449
I think each page = 8KB, so you could add a calculation to the SELECT clause:
SELECT
COUNT(*)AS cached_pages_count,
COUNT(*)/128.0 AS Cached_MB