Pregunta de entrevista de Tata Consultancy Services

How do you diagnose slow query performance

Respuestas de entrevistas

Anónimo

20 ago 2010

based on the situation and criticality, check the following things: status of the database Is it specific to single query Check memory/CPU usage Check statistics Chec the plan and see if there is any deviation Use hints

1

Anónimo

22 may 2019

Check memory/CPU usage

1