memory usage

Hi, can I get the SQL service memory usage?
and which one holding lots of memory?See Profiler for this
Otherwise Set Show Execution plan at QA and run the query
Madhivanan|||See Profiler for this
Otherwise Set Show Execution plan at QA and run the query
Madhivanan|||You can use 'dbcc memorystatus':
http://support.microsoft.com/kb/271624
-oj
"js" <js@.someone@.hotmail.com> wrote in message
news:%23%23YwunrUFHA.4000@.TK2MSFTNGP14.phx.gbl...
> Hi, can I get the SQL service memory usage?
> and which one holding lots of memory?
>|||Hi,
You can use PERFMON to get the memory usage.
Thanks
Hari
SQL Server MVP
"js" <js@.someone@.hotmail.com> wrote in message
news:%23%23YwunrUFHA.4000@.TK2MSFTNGP14.phx.gbl...
> Hi, can I get the SQL service memory usage?
> and which one holding lots of memory?
>|||Hari Whne I run PERFMON at Query Analyser,
I get the error
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'PERFMON'.
Madhivanan|||Hari was referring to the Windows tool "Performance Monitor", aka "System Mo
nitor".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1115459019.983953.289570@.o13g2000cwo.googlegroups.com...
> Hari Whne I run PERFMON at Query Analyser,
> I get the error
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'PERFMON'.
> Madhivanan
>|||that's it. thanks for the info
"oj" <nospam_ojngo@.home.com> wrote in message
news:%231G47RtUFHA.3428@.TK2MSFTNGP10.phx.gbl...
> You can use 'dbcc memorystatus':
> http://support.microsoft.com/kb/271624
>
> --
> -oj
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:%23%23YwunrUFHA.4000@.TK2MSFTNGP14.phx.gbl...
>