Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Some time Stored Procedure suddenly taking 10 seconds when we called through application. RE: Some time Stored Procedure suddenly taking 10 seconds when we called through application.

  • August 22, 2014 at 7:30 am

    #1740213

    I also noticed that the OP doesn't mention the normal time it takes to run. It's possible that 10 seconds could actually be an improvement. Things inexplicably running better can be as puzzling as them slowing down.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537