<div>
... and sizes of database/datafiles ...
</div>


<div>
Edition: Microsoft SQL Server 2005 - 9.00.5000.00 (X64) &nbsp; Dec 10 2010 10:38:40 &nbsp; Copyright (c) 1988-2005 Microsoft Corporation &nbsp;Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) <br />
<br />
max degree of parallelism: Config Value:1 Run Value:1<br />
Max Memory : 44032<br />
Min Memory : 44302<br />
Total Memory: 49142<br />
Dedicated Database Server and Single Instance<br />
<br />
Database Size : 3.1 TB<br />
<br />
Please review above details and waiting for response.<br />
<br />
Thanks,<br />
Chandra
</div>


<div>
Hi,<br />
<br />
Some simple performance rules of thumb - scans are bad, seeks are good. <br />
<br />
When things are big, they need to be well tuned to work acceptably. When things are small then almost anything works brilliantly.<br />
<br />
My questions are why is DOP set to 1? When was it last tested?<br />
<br />
Are you doing index maintenance? When was it done last?<br />
<br />
Regards<br />
&nbsp; David
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
My Application users getting slowness for web search queries. I have checked the server and found no blocking issues.<br />
<br />
No high cpu utilization processes and Disk IO utilization is normal.<br />
<br />
Server Configuration:<br />
Version : MS SQL Server 2005<br />
Dedicated LUNS for MDF, NDF , INDEX and LDF Files.<br />
Memory : 49GB<br />
Processors: 24.<br />
Integrity Check, Update stats and Re-indexing jobs configures on weekly bases and Latest status is successful<br />
<br />
As per my observation found PLE is 222 and Users getting the following error also.<br />
<br />
&quot;Could not continue scan with NOLOCk due to data movement&quot;<br />
<br />
Please provide steps for trouble shooting this issue.<br />
<br />
Thanks,<br />
Chandra
</div>
</div>


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

Page Life Expectancy is 222 in SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.