Gopal
Reputation: 1340
Stored Proc slower from application than Management Studio
We have a stored proc which runs pathetically when called from application (Spring - DBCP - jtds) infact timesout after 10 minutes, but runs in 30 seconds when executed from SQL Server Managament Stuido. Can someone provide leads into this issue?
Upvotes: 0
Views: 322
Answers (1)
Martin Smith
Reputation: 453756
This normally indicates a parameter sniffing issue.
See Slow in the Application, Fast in SSMS? Understanding Performance Mysteries for details.
Upvotes: 2
Related Questions
- Executing stored proc from DotNet takes very long but in SSMS it is immediate
- SQL Server Stored Proc takes (much) longer to run than the same query executed from text in Management Studio
- SQL faster in ssms than in application
- Stored procedure slow when executed from application server
- Java stored procedure running slow
- Stored proc running 30% slower through Java versus running directly on database
- Strange performance Issue with SQL Server + Spring JAVA application
- Big difference in execution time of stored proc between Managment Studio and TableAdapter
- SQL Server proc running 5x slower than plain query
- Stored proc executes >30 secs when called from website, but <1 sec when called from ssms