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.
Version : MS SQL Server 2005
Dedicated LUNS for MDF, NDF , INDEX and LDF Files.
Memory : 49GB
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.