Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2010-09-17 : 00:58:52
|
| Dear Experts,What is the optimal value for PAGE LIFE EXPECTANCY in OLTP DATABASE.Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-09-17 : 04:46:46
|
It depends.Are going to read the data often? Or just copy the data to a datawarehouse once per day?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2010-09-17 : 08:06:19
|
| Thanks for the reply ,The system is OLTP database. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-09-17 : 09:42:24
|
It depends.Are going to read the data often? Or just copy the data to a datawarehouse once per day?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-17 : 11:18:16
|
| Microsoft technet state that "<i>Memory bottleneck if Consistently low average page life expectancy. See Average Page Life Expectancy Counter which is in the Perfmon object SQL Server Buffer Manager (this represents is the average number of seconds a page stays in cache). For OLTP, an average page life expectancy of 300 is 5 minutes. Anything less could indicate memory pressure, missing indexes, or a cache flush</i>"---Thanks---Santosh |
|
|
|
|
|
|
Page life expectancy