Any good link on tracking memory issues

I have always found it hard to figure out if SQL has memory issues using
tools like perfmon,etc..
Its easy for CPU and IO i.e. high CPU or disk queue, but could never figure
out how to go about memory.
Yes some may say look at DBCC memorystatus,etc.. but that things greek ;)
Can someone help or maybe theres some documentation that talks about
tracking memory usage,etc. for SQL Server..Hi Hassan,
Two excellent sources I know are:
Paper "Troubleshooting Performance Problems in SQL Server 2005"
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
Chapter 1, book "Inside SQL Server 2005: Query Tuning and Optimization"
by Kalen Delaney, et al.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I have always found it hard to figure out if SQL has memory issues using
> tools like perfmon,etc..
> Its easy for CPU and IO i.e. high CPU or disk queue, but could never figure
> out how to go about memory.
> Yes some may say look at DBCC memorystatus,etc.. but that things greek ;)
> Can someone help or maybe theres some documentation that talks about
> tracking memory usage,etc. for SQL Server..
>
>