page-life-expectancy Archives

Unexplained PLE drop

By adminPosted on September 9, 2023

Question : Our SQL server has 512 GB ram with 448 GB available to SQL 2012 (sp2, cu7) serving a […]

By adminPosted on August 31, 2023

Question : This question already has answers here: What does Page Life Expectancy say about the instance? (2 answers) Closed […]

By adminPosted on August 18, 2023

Question : Looking at performance data I realized sudden drops of Page Life Expectancy on a Sql Server 2016 SP1 […]

By adminPosted on July 30, 2023

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 17, 2023

Question : For one of our SQL Server, we recently add more memory. The initial value was 12GB. The server […]

By adminPosted on May 1, 2023

Question : I have several large tables that I need to copy into partitioned copies on a transactional database. I […]

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 […]