Forum Discussion

madhav33's avatar
madhav33
Copper Contributor
Aug 15, 2022

Performance issue in Production box

Hi Folks,   I have one query which will give only 192 records from database tables. In that query multiple SQL views are used.   When I am executing that query in Production it is taking 3 mins b...
sql server 2014
KanishkaB's avatar
KanishkaB
Copper Contributor
Aug 16, 2022

madhav33 did you check the number of records that is being traversed in both production and test and are there identical indices in both, can you share the  plan here.

Resources