Slow DB Performance. Seems to be memory related.
- by David
I am seeing a pooorly performing web app with a SQL 2005 backend. The db is on a w2k3 machine with 4GB RAM.
When I run perfmon on it I see the following.
Page life expectancy is low. Consistently under 300 while the Buffer cache hit ratio is always 99% +.
The target server memory is always 1618304 and the total server memory is always a number…