Find memory used by particular Database

Question

Post reply

Find memory used by particular Database

rahulgsingh

SSC-Addicted

Points: 498
More actions
December 18, 2012 at 1:31 am

#271710

Comments posted to this topic are about the item Find memory used by particular Database

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

marie contencin Grasshopper Points: 16 More actions · Answer 1

I am very surprised to find in experts forum scripts that are in sql2005 BOL:-)

kasi5445 Grasshopper Points: 24 More actions · Answer 2

Hi Rahul,

I executed the first query and my DB has retured value 486763 on cached_count_pages. We have allocated 6.5 GB memory for the DB. so as per this result how i would i know the allocated memory is sufficient or not?

Regards,

Kasi

The Wizard Of Oz SSC Eights! Points: 875 More actions · Answer 3

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

kasi5445 Grasshopper Points: 24 More actions · Answer 4

kasi5445

Grasshopper

Points: 24

December 18, 2012 at 4:18 am

#1569470

I got it..Thanks Orestes 🙂

--Kasi

rw_ebox SSC Eights! Points: 802 More actions · Answer 5

rw_ebox

SSC Eights!

Points: 802

December 18, 2012 at 9:19 am

#1569645

A good sql query.

Thanks

brandon.lukes Valued Member Points: 74 More actions · Answer 6

I also found this on BOL. Would have been more helpful if contained some additional information.