The most recent content from our members.
DPA will tell me about how much time is spent waiting for memory allocations (although only aggregated with other memory and CPU waits), but that doesn't tell me which statements executing during a time period used the most buffer cache, which is generally what causes a Page Life Expectancy drop. If I drill into the…
Page Life Expectancy (PLE) is a metric often used to determine the health of the SQL Server buffer cache. A low PLE value indicates pages are not staying in cache very long and could indicate a variety of issues. My experience is that many people alert on a low PLE value, but then do not have the data to understand what…
DPA is only monitoring the average PLE, not the PLE of the individual buffer pools. I would like DPA enhanced to do that. This is already a feature of SQL Sentry (http://sqlperformance.com/2014/10/sql-performance/knee-jerk-page-life-expectancy). The article Page Life Expectancy isn't what you think... - Paul S. Randal…
I was just reading an interesting article (Page Life Expectancy isn't what you think... - Paul S. Randal) that states the following: Most new systems today use NUMA, and so the buffer pool is split up and managed per NUMA node, with each NUMA node getting it’s own lazy writer thread, managing it’s own buffer free list, and…
It looks like you're new here. Sign in or register to get started.