I have a long running process that is mostly executing combinatorial operations through T-SQL stored procs. the longer it runs, the more ram it uses, the lower the % processor statistic falls, and the fewer operations per minute the process performs. The first hour is solid, but within 24 hours the process slows to 50%. Is there anything specific to T-sql that causes performance degradation over time on a long running process? This is a dedicated server with 30+ gb of ram and quality processors.