Post reply

Stored procedure taking less time in local and taking more time in testing serve

  • March 31, 2019 at 11:18 am

    #2232886

    My stored procedure is running fast (2 sec) for particular parameter in local server with 25 million rows in the table, but on the testing server, it takes 15 seconds with only five million rows. How to find out the reason? Is there any query to find the server and database properties of servers?

  • March 31, 2019 at 1:46 pm

    #2243203

    jkramprakash wrote:

    My stored procedure is running fast (2 sec) for particular parameter in local server with 25 million rows in the table, but on the testing server, it takes 15 seconds with only five million rows. How to find out the reason? Is there any query to find the server and database properties of servers?

    Post the execution plans for both!

    😎

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply