Home Forums SQL Server 2014 Administration - SQL Server 2014 Query performing differently in different environments RE: Query performing differently in different environments

  • August 29, 2016 at 6:32 am

    #1898060

    dan.brown1 (8/29/2016)

    Hi,

    In my Prod & Non-Prod, we use a stored proc to pull a list of rows. In non-prod sql server, query completes in 2seconds but in prod it would take 1 min 40sec. Stored proc queries only 3 tables, and they aren't huge. SQL server version,configuration is similar. Validated indexes, keys, fragmentation, last stats updated and they looks good. Execution plan in QA is considering parallelism and had a higher subtree cost(41.456), whereas in prod it is not considering parallelism and have very less subtree cost (3.33). How should i proceed further, please help me on this.

    Thanks,

    Dan

    Please post the actual execution plans here as attachments and let others take a look too.

    Also, is there anything running in prod at the same time which may be blocking the proc?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.