Stored procedure slow when called from web, fast from Management Studio

by

I’ve had a similar issue arise in the past, so I’m eager to see a resolution to this question. Aaron Bertrand’s comment on the OP led to Query times out when executed from web, but super-fast when executed from SSMS, and while the question is not a duplicate, the answer may very well apply to your situation.

In essence, it sounds like SQL Server may have a corrupt cached execution plan. You’re hitting the bad plan with your web server, but SSMS lands on a different plan since there is a different setting on the ARITHABORT flag (which would otherwise have no impact on your particular query/stored proc).

See ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException for another example, with a more complete explanation and resolution.

More Related Contents:

  1. Error – SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
  2. An attempt to attach an auto-named database for file ….database1.mdf failed
  3. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  4. HTTP Error 500.22 – Internal Server Error (An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.)
  5. SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified [closed]
  6. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  7. what’s the issue with AttachDbFilename
  8. Server.Transfer Vs. Response.Redirect
  9. Custom MembershipProvider in .NET 4.0
  10. How to set the Default Page in ASP.NET?
  11. How to use jQuery to call an ASP.NET web service?
  12. Forms Authentication Timeout vs Session Timeout
  13. Unable to start debugging on the web server. Could not start ASP.NET debugging VS 2010, II7, Win 7 x64
  14. Can you recommend a .net template engine? [closed]
  15. IIS URL Rewrite and Web.config
  16. “The system cannot find the file specified”
  17. Allow access for unathenticated users to specific page using ASP.Net Forms Authentication
  18. HttpServerUtility.UrlPathEncode vs HttpServerUtility.UrlEncode
  19. How to implement oauth2 server in ASP.NET MVC 5 and WEB API 2 [closed]
  20. How to decode viewstate
  21. IIS application using application pool identity loses primary token?
  22. ASP.NET 2.5 prefixing ctl00 and ASP.NET 4 not prefixing ctl00
  23. Entity Framework v2 doesn’t support sql 2000?
  24. Visual Studio Do not open new browser instance
  25. Duplicate ‘Content’ items were included. The .NET SDK includes ‘Content’ items from your project directory by default
  26. C# ASP.NET Send Email via TLS
  27. Does the Razor View Engine work for Mono?
  28. IIS and Static content?
  29. Differences between App.Config and Web.Config?
  30. Could not load type ‘site._Default’ [closed]

Leave a Comment