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 |
|
eddiefdz
Starting Member
21 Posts |
 Posted - 2008-08-08 : 10:52:47
|
| Hello All,When i take a look at the "page life expectancy" counter for SQL, i see that it is constantly at 90seconds. I read somewhere that this is not normal becuase it means that it is writing to the disk too often. Is this really the case? They tell me that it should be no less than 300, the higher the better. I have a SQL 2005 ENT Cluster running on two 2950's with Dual quad cores and 16 GB of RAM. I have set the Max RAM in SQL to 12888MB to leave the OS with 4GB. Any ideas if my settings are correct and if i should be worried about the page life expectancy counter?Thanks!Eddie FernandezIT DirectorMTech |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-08 : 13:36:28
|
| What edition you have ?Is it 64-bit or 32-bit? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:32:08
|
| Basically, you need more memory to keep data in buffer longer. |
|
|
|
|
|
|
Page life expectancy counter for SQL