The issue is steady. test database is a copy and no new data input and no other user can login. Same performance even only single user in prod server....

Thanks for reply.

There is no block process in prod.

SQL server setting are the same. Windows might be little bit different.

Execution plans are similar. ...

Thanks for all your reply. I did have a chance to check web yesterday. I will try Paul's tip and report the result.

Recompiling is what I guessing in the...

1) Disable AWE first.

2) Run DBCC MEMORYSTATUS to check the actual memory used by SQL Server. Your SQL Server may lightly memory hit.

3) If you want SQL Server to...

Hi all,

Thank for all your reply. That's help a lot.

The SQL 2005 is in Enterprise edition. One thing we know that is server option Max Server Memory is only...

Jeffery,

Thanks for your reply.

1)This is a new install.

2) a kind of dedicate SQL Server box, other components should not use much memory.

3) didn't set Lock pages in...

Jeffery,

Right, SQL Server shouldn't use page file at all. But I have seen in my 64 bit environment, SQL Server not release memory back to system even it...

Page file size is matter in 64 bit of SQL 2005. SQL may not use it but require the size is at least 1.5 times of RAM size. Otherwise,...