We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [page-life-expectancy]

Page Life Expectancy is a Microsoft SQL Server-specific term relating to the average amount of time buffer pages can be expected to remain in memory before being replaced.

Filter by
Sorted by
Tagged with
0
votes
2answers
3k views

Page Life Expectancy sudden drop

Looking at performance data I realized sudden drops of Page Life Expectancy on a Sql Server 2016 SP1 running on VMWare consuming 58982 MB of 64 GB RAM. The previous value of PLE was around 133,000 and ...
-1
votes
1answer
280 views

Unexplained PLE drop

Our SQL server has 512 GB ram with 448 GB available to SQL 2012 (sp2, cu7) serving a typical OLTP workload. The server is only for SQL other than SIOS for geo clustering. There is not a big swing in ...
1
vote
3answers
65 views

Identify cached data for a specific query in data cache

I'm trying to identify, if possible, how long it takes for data being cached by a stored procedure to be taken out of the cache. I know there is the PLE counter in sys.dm_os_performance_counters, but ...
1
vote
2answers
733 views

Interpreting Page Life Expectancy metric

I need advise on interpreting PLE metric of my server which: is SQL Server 2008 R2 with 4 NUMA nodes with 128 GB RAM Daily full backups start at 02:00 AM and takes around 1 hour to complete. ...
3
votes
3answers
7k views

SQL Server Memory allocation and max server memory setting

For one of our SQL Server, we recently add more memory. The initial value was 12GB. The server experienced a lack of physical memory so we added another 12GB, for a total of 24GB. Then I have set the ...
1
vote
3answers
7k views

Page life expectancy very low on certain time?

Everyday we receive an alert on a specific period (03:00 AM - 04:00 AM) indicating that Page life expectancy is too low : SCOM :Alert: SQL DB 2008 Engine Page Life Expectancy is too low We have ...
5
votes
3answers
14k views

How much RAM should SQL Server have [duplicate]

I have a database which takes up 500gb, I have noticed that my ple is low even though I have 100gb of RAM. I have searched in google to find reasons of that and I found some interesting queries. I ...
3
votes
2answers
629 views

Dropping PLE on query

In company we are working in project on very big database. It uses 100GB RAM. What's weird before first running a query PLE is 11k~, after running it drops to about 70, anyway when after 15 mins I ...
3
votes
2answers
310 views

Can I tell SQL Server not to place data in the buffer cache?

One of the servers I support has an ETL job that runs every morning. This isn't an SSIS package, just a series of stored procedures executed via SQL Server Agent. The job takes several hours to run, ...
2
votes
0answers
285 views

SQL Server 2012; Incorrect PLE buffer manager value for NUMA server

We are receiving PLE alerts from SCOM for several instances. These instances are on hardware servers, and use NUMA nodes. SQL Server 2012 SP1 CU7 Enterprise Edition is installed. Memory is fixed and ...
2
votes
1answer
376 views

Why is Page Life Expectancy value sometimes exceptionally high (4,3 M)?

My value of PAGE LIFE EXPECTANCY usually is in a range of 3000 - 10000. But as you can see in the little data sample below, there are regular values of about 4,3 Milion. I get those values using ...
6
votes
4answers
954 views

How can I Debug a Buffer Issue?

I have a production "Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)" that is showing weird buffer and page life expectancy (PLE) symptoms. I am running this every minute on my server (to track ...
6
votes
2answers
2k views

Buffer Size Changing?

I have a production database that is experiencing wildly fluctuating Page Life Expectancy (PLE) issues. (It crashes to zero at random times.) I have been researching the PLE issue and have found ...
4
votes
1answer
307 views

Page Life Expectancy Wildly Fluctuating

For months now, the PLE on one of our servers has hovered around the 2 million seconds. If varied slightly from day to day but was pretty stable there. This last weekend, we added 12 GB of virtual ...
5
votes
1answer
111 views

Does Resource Governor help protect page life expectancy?

I have several large tables that I need to copy into partitioned copies on a transactional database. I am worried about the hit that this will cause to performance of my production applications. In ...
8
votes
1answer
9k views

Can SQL Server's Page Life Expectancy be too high?

I've read several articles about SQL Server's Page Life Expectancy and what it means and what kind of information you can glean from it. In most of these articles that I've read, a common, healthy PLE ...
9
votes
2answers
3k views

What does Page Life Expectancy say about the instance?

I have installed monitoring software on a few SQL Server instances in the environment. I am trying to find bottlenecks and fix some performance issues. I want to find out if some servers need more ...
0
votes
3answers
1k views

Is it normal that occasionally Page Life Expectancy drops to 0 and queries start giving timeouts in SQL Server? [duplicate]

Can somebody shed some light on if it's normal that Page Life Expectancy drops occasionally to 0 in SQL Server (2014) resulting in slow queries and timeouts? I'm facing this on my developer machine ...
12
votes
1answer
3k views

SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days

I've noticed an odd behavior on a 2-server HA cluster and I was hoping someone could confirm my suspicion, or maybe offer some other explanation... Here is my setup: A 2-server SQL 2012 SP1 ...
3
votes
0answers
194 views

Significant PLE Drop [duplicate]

This morning at 4am we experienced a huge drop in Page Life Expectancy on a new sql server 2012 box. No jobs (backup etc) ran at this time and traffic was very light compared to say 20:00. Current ...
3
votes
4answers
5k views

SQL Server Page Life Expectancy sharp drop

I'm trying to put my hands on the reason this SQL Server slows down sporadically. There are no patterns detected so far. It's a SQL Server 2008 R2 running on a Windows Server 2008R2 VM on top of ...
8
votes
1answer
1k views

Why is the page life expectancy 0 (zero) on SQL Server 2005

We have been wanting to know the page life expectancy for our SQL Server. So we look at the counter using Perform. The value is ZERO and never changes. I thought there must be some bug, so I checked ...
5
votes
1answer
817 views

What units is Page Life Expectancy in?

I'm currently using the following query to get the Page Life Expectancy from SQL Server: declare @PLE int select @PLE=cntr_value from psql1.master.sys.dm_os_performance_counters where counter_name=...