Hi all... I am new to this forum and to the SQL 2005 world. I have a database on a Windows 2003 Enterprise platform with SQL 2005 SP2 Enterprise with 8GB RAM configured on the server. SQL is configured to utilise 7GB RAM for itself and PAE switches are enabled to that effect. We have noticed that when we perform searches on a table that contains 2 million rows, the results are extremely slow to come back. We have applied optimise stats on that table and it contains a valid index as well. But still for some reason, the searches are slow to process. The memory utilisation during that time is between 80 - 90% during the course of the process. Sometimes, the searches fail with timeouts. Can you please advise whether there is anything that I can check to confirm what may be going on? I ran Profiler trace as well to gather some statistics but cannot see where the problem lies. Any advice would be highly appreciated.