I have a stored procedure in my SQL Server 2008 database on Winhost that runs in about 2 seconds when I execute it using SQL Server Management Studio (SSMS). But when the same procdedure is called by my ASP.NET 4.0 application, it takes 20 seconds or more to execute. Troubleshooting I've done: 1) The stored proc is called by my ASP.NET app using a TableAdapter. In VS2010 you can get a preview of the data by clicking on the TableAdapter in the designer view. The stored proc takes over 20 seconds to return when called this way too. 2) I can execute the stored proc directly via the Server Explorer in VS2010. It takes over 20 seconds to return here as well. 3) I have the identical database on another hosting service, MochaHost, when I execute the stored proc via VS2010 it runs in 2 seconds, just like it does via SSMS on MochaHost- so on MochaHost the sproc isn't slow when executed via VS2010 or ASP.NET. (But, I'm considering leaving MochaHost for Winhost since MochaHost's control panel is painfully slow.) Does anyone have any idea why a proc would run 10 times faster when executed via SSMS vs. VS2010 or an ASP.NET app?