How to find current memory usage using SQL?

Anybody knows of any DBCC command or sp_configure param
which would tell me how much memory is SQL Server
currently grabbing?
I don't want to use DBCC perfmon(lrustats) because (1) it
is being deprecated and (b) the output is voluminous.
Using performance monitors is not an option since I want
to be able to do this from within a SQL script.
Thx a bunch!Check out master..sysperfinfo. The values in this table are not completely
cooked. Check out msdb..sp_sqlagent_get_perf_counters to see how the counter
values can be cooked.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Asim" <aabubba@.yahoo.com> wrote in message
news:1fc7001c38a3b$4f2fc4a0$a601280a@.phx.gbl...
> Anybody knows of any DBCC command or sp_configure param
> which would tell me how much memory is SQL Server
> currently grabbing?
> I don't want to use DBCC perfmon(lrustats) because (1) it
> is being deprecated and (b) the output is voluminous.
> Using performance monitors is not an option since I want
> to be able to do this from within a SQL script.
> Thx a bunch!