1

New focus : What parameters can have an impact on "number of logical reads" ?

UAT and PROD environments are supposed to be the same but "number of logical reads" is huge for PROD.

enter image description here

Exec plans on UAT & PROD

Detailed problem => Not solved

Thanks in advance! :)

Community
  • 1
  • 1
Steph_P92
  • 35
  • 1
  • 5
  • 1
    Possible duplicate of [SQL server 2014: different performances (huge "number of executions") with same VMs](http://stackoverflow.com/questions/40680403/sql-server-2014-different-performances-huge-number-of-executions-with-same) – Radu Gheorghiu Nov 22 '16 at 14:41

0 Answers0