Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Stored Procedure runs fine on the Production Server and two Test Server but not on the replicated Server. RE: Stored Procedure runs fine on the Production Server and two Test Server but not on the replicated Server.

  • August 26, 2015 at 6:50 am

    #1822446

    ScottPletcher (8/25/2015)

    Check the statistics on the replicated server, make sure they are current (or at least as current as the other servers).

    I updated the statistics and the execution time dropped from over 5 minutes down to 3 minutes. Thank you.:-)

    Now I need to look into the recommendations made by the other posts.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/