Chandra Mohan Kanithi
asked on
Page Life Expectancy is 222 in SQL Server 2005
Hi,
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.
Thanks,
Chandra
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.
Thanks,
Chandra
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
... and sizes of database/datafiles ...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Edition: Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
max degree of parallelism: Config Value:1 Run Value:1
Max Memory : 44032
Min Memory : 44302
Total Memory: 49142
Dedicated Database Server and Single Instance
Database Size : 3.1 TB
Please review above details and waiting for response.
Thanks,
Chandra
max degree of parallelism: Config Value:1 Run Value:1
Max Memory : 44032
Min Memory : 44302
Total Memory: 49142
Dedicated Database Server and Single Instance
Database Size : 3.1 TB
Please review above details and waiting for response.
Thanks,
Chandra
Hi,
Some simple performance rules of thumb - scans are bad, seeks are good.
When things are big, they need to be well tuned to work acceptably. When things are small then almost anything works brilliantly.
My questions are why is DOP set to 1? When was it last tested?
Are you doing index maintenance? When was it done last?
Regards
David
Some simple performance rules of thumb - scans are bad, seeks are good.
When things are big, they need to be well tuned to work acceptably. When things are small then almost anything works brilliantly.
My questions are why is DOP set to 1? When was it last tested?
Are you doing index maintenance? When was it done last?
Regards
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.