Trace flag 8030 for SQL 2005
FIX: Query performance may decrease after SQL Server 2005 has been running for a while
Consider the following scenario. A server has been running for a while. Then, you run a query in Microsoft SQL Server 2005. In this scenario, the query performance may be slow.
This problem occurs only on 64-bit servers that have more than 16 gigabytes (GB) of physical memory.
You do not have to restart the computer after you apply this hotfix. However, after you apply this hotfix, you must add the -T8030 option as a SQL Server startup parameter to enable trace flag 8030. Then, you must restart the SQL Server service for the hotfix to take effect.