check memory pressure

Whats the easy way to check for memory pressure to SQL or if its time to add
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
ThanksAre you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:

> Whats the easy way to check for memory pressure to SQL or if its time to a
dd
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/downl...otPerfProbs.doc
thanks,
--
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...[vbcol=seagreen]
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
>|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/d.../>
on_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/ar...5&seqNum=2&rl=1
"Hassan" wrote:

> Whats the easy way to check for memory pressure to SQL or if its time to a
dd
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks