Query to get max and min memory setting as well as how much memory actually in use

This query gives the numer of pages in memory ans how much memory those are using. max and min memory is also given to enable a comparizon of the values. Note, a low memoery does not necesarily means that the instance is not using all the available memeory! The values we se is the CURRENT values. If we haven´t had any activities for a while the data pages might have been swaped out.

select count(*) AS Buffered_Page_Count
,cast(count(*) as bigint) * 8192 / (1024 * 1024) as Buffer_Pool_MB
from sys.dm_os_buffer_descriptors
go
sp_configure 'max server memory'
go
sp_configure 'min server memory'