Hi troops. I recently tweaked a stored proc as it was running slow and doing far too many reads. Now, when I run the stored proc from the app (asp.net using standard SqlConnection, SQL authentication) it still runs slow. Run it from QA using same login, and it flies a factor of 100 faster. Instead of 400,000 reads it does 4,000 or sometimes a few hundred. Duration typically 300ms instead of 15 seconds. All 100% consistent ( I can run some from QA, some from the app, and always the same result - not likely to be a caching issue). Why? I am using the exact same SQL (as obtained from Profiler) that the app uses. I checked this FAQ: http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=32 and the ARITHABORT makes no diff. Thanks for any tips! Mike.