March 28, 2010 at 11:23 pm
Hi,
We have SQL Server 2005 EE x64 with SP3. We have 4 named instances on the same server
1. For each instance, Max memory is set to 3GB and left 4 GB for OS & Min memory is set to default
value.
2. Lock pages in memory has enabled
3. We did not see any performance issues from users.
4. We ran DBCC CHECKDB for all database for 4 instances and for one of the instances, the page life expectancy goes very low like 70 sec, while running DBCC CHECKDB
Is this normal to get low page life expectancy when we run DBCC CHECKDB?
But it's low for only one instance & for other 3 instances, PLE is >300
thanks
March 29, 2010 at 12:45 am
Mani-584606 (3/28/2010)
We ran DBCC CHECKDB for all database for 4 instances and for one of the instances, the page life expectancy goes very low like 70 sec, while running DBCC CHECKDB. Is this normal to get low page life expectancy when we run DBCC CHECKDB?But it's low for only one instance & for other 3 instances, PLE is >300
Sure, it is normal. DBCC CHECKDB may have to bring in a whole load of new pages from persistent storage to do its work. The effect depends on many factors, including the size of the database being checked, and how many pages were in the data cache to begin with.
PLE is generally only worth monitoring over time - spikes of low values, especially when a maintenance procedure is being run, are not usually a concern.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply