Avatar of Chandra Mohan Kanithi
Chandra Mohan Kanithi
Flag for India

asked on 

Page Life Expectancy is 222 in SQL Server 2005


My Application users getting slowness for web search queries. I have checked the server and found no blocking issues.

No high cpu utilization processes and Disk IO utilization is normal.

Server Configuration:
Version : MS SQL Server 2005
Dedicated LUNS for MDF, NDF , INDEX and LDF Files.
Memory : 49GB
Processors: 24.
Integrity Check, Update stats and Re-indexing jobs configures on weekly bases and Latest status is successful

As per my observation found PLE is 222 and Users getting the following error also.

"Could not continue scan with NOLOCk due to data movement"

Please provide steps for trouble shooting this issue.

Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon