page-life-expectancy Archives

Dropping PLE on query

By adminPosted on April 14, 2022

Question : In company we are working in project on very big database. It uses 100GB RAM. What’s weird before […]

By adminPosted on January 4, 2022

Question : This question already has answers here: What is a deterministic method for evaluating a sensible buffer pool size? […]

By adminPosted on September 5, 2021

Question : One of the servers I support has an ETL job that runs every morning. This isn’t an SSIS […]

By adminPosted on June 29, 2021

Question : As I understand it, when you define a column on a table you define its precision. This precision […]

By adminPosted on May 29, 2021

Question : I’m currently using the following query to get the Page Life Expectancy from SQL Server: declare @PLE int […]

By adminPosted on March 30, 2021

Question : This question already has answers here: What is a deterministic method for evaluating a sensible buffer pool size? […]

By adminPosted on March 28, 2021

Question : I’m trying to put my hands on the reason this SQL Server slows down sporadically. There are no […]

By adminPosted on September 29, 2020

Question : We have been wanting to know the page life expectancy for our SQL Server. So we look at […]

By adminPosted on August 12, 2020July 2, 2022

Question : I’ve noticed an odd behavior on a 2-server HA cluster and I was hoping someone could confirm my […]

By adminPosted on July 27, 2020

Question : For months now, the PLE on one of our servers has hovered around the 2 million seconds. If […]