Question : In company we are working in project on very big database. It uses 100GB RAM. What’s weird before […]
Tag: page-life-expectancy
How much RAM should SQL Server have [duplicate]
Question : This question already has answers here: What is a deterministic method for evaluating a sensible buffer pool size? […]
Can I tell SQL Server not to place data in the buffer cache?
Question : One of the servers I support has an ETL job that runs every morning. This isn’t an SSIS […]
DateTime2 and Page Life Expectancy (PLE)
Question : As I understand it, when you define a column on a table you define its precision. This precision […]
What units is Page Life Expectancy in?
Question : I’m currently using the following query to get the Page Life Expectancy from SQL Server: declare @PLE int […]
How much RAM should SQL Server have [duplicate]
Question : This question already has answers here: What is a deterministic method for evaluating a sensible buffer pool size? […]
SQL Server Page Life Expectancy sharp drop
Question : I’m trying to put my hands on the reason this SQL Server slows down sporadically. There are no […]
Why is the page life expectancy 0 (zero) on SQL Server 2005
Question : We have been wanting to know the page life expectancy for our SQL Server. So we look at […]
SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days
Question : I’ve noticed an odd behavior on a 2-server HA cluster and I was hoping someone could confirm my […]
Page Life Expectancy Wildly Fluctuating
Question : For months now, the PLE on one of our servers has hovered around the 2 million seconds. If […]