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 |
|
lluisdelta
Starting Member
9 Posts |
 Posted - 2008-09-03 : 14:43:37
|
| Hi,I have a SQL Server 2005 running on a Win 2k3 x64.We are having some performance issues and I looked in the Performance logs trying to find why. According to what I've read, Page life expectancy should be around 300 (5 minutes). But in my case it is way higher (2669783 and growing). It never goes down. I havent seen any reference to that counter too high!!... Could that be an indicator of something wrongly configured, say that the pages are never hit by the server and the server is reading directly from the databases, or something like that?Any ideas why this counter is constantly growing?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-03 : 16:07:27
|
| That number indicate that pages are saying in memory for over 30 days on average. The larger this number is, the more likely that a database page will already be in memory when you need to access it, so the larger the better.This is probably an indication that the memory that you have allocated to SQL Server is as large or larger than the database, so SQL Server never needs to remove pages from memory.One thing you should check is to make sure that SQL Server is not configured to use more memory than the amount of physical memory. That would cause memory to be paged out by the OS, and would cause very bad performance.CODO ERGO SUM |
 |
|
|
lluisdelta
Starting Member
9 Posts |
Posted - 2008-09-03 : 16:28:25
|
| Thanks so much for your replies. I will keep looking somewhere else for the performance issues then. |
|
|
|
|
|
|
Page life expectancy too never drops