That link is just the page that DOES load. that article has a link embedded that no longer works.

I guess an alternative to providing a fixed link would be to...

Try setting min and max to the same value to disable dynamic memory management by SQL Server. I'm just curious if it fixes your random issues with performance monitor.

If you...

@epfax,

Most of the time you should be looking for consistently bad stats. Some stats are not as consistent in my opinion. E.g., Memory Grants Outstanding. You always want...

@ Old Hand,

I recommend using this for that:

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

Chapter 2 specifically.

One key thing is that the thresholds are best determined...

Sapen,

I recommend using this for that:

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

Chapter 2 specifically.

One key thing is that the thresholds are best determined by comparing...

Ron,

Thanks for taking the time to write an article using a real world example of why DMVs can be much more powerful than their Performance Monitor counterpart.

Would you say...

I highly recommend subscribing to the SQLServerCentral.com lists. Just skim the e-mail for anything new you want to learn about. If it has nothing, delete it. If it's something interested,...