thanks for the advise.

understand it can still be used in 2014... however it may be deprecated in later release.

https://msdn.microsoft.com/en-us/library/ms151229.aspx

thanks!

Hi,

Can advise on how do I add up to the total server memory from the below?

thanks

Memory Manager ...

hi guys,

anyone can advise?

thanks

Hi Chris,

thanks for your help.

My output as below:

1)

-- Memory usage by the SQL Server process.

4.1 GB - Physical memory in used

2)

-- Get total buffer usage by database

135MB - i have...

hi zealot,

appreciate ur help.

this return a value of 19gb, doesn't really tally.

thanks!

Hi Perry,

actually wish to find out which "kind" of pool is using the total memory breakdown..

for eg:

plan cache

buffer <data? cache> etc.

thanks

Hi Chris,

You could use DBCC MEMORYSTATUS.

>> which area must i look into it? wish to find the components that adds up to the commit memory.

thanks

hi guys, anyone can advise me? thanks!!

Hi Yuri,

Does it means that:

1. the additional 1gb is allocated to sql server but not in used?

2. since only 500mb of data is cached in the buffer pool now, how...

Apology, it's the total server memory that is showing 1.5GB.

I'm curious as since from the dmv it shows that only 0.5GB was used for cahing data, where is the remaining...

Hi Yuri,

thanks for the reply.. in this case why is it holding to 1.5GB.. the exe process.

Hi Jeffrey,

thanks so much for ur explanation.

Which means to say for my current scenario setting the awe doesn't helps at all as boot.ini is set to /PAE. The sql server...