Pregunta de entrevista de Tata Consultancy Services

How do you diagnose slow query performance

Respuestas de entrevistas

Anónimo

20 de ago de 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 de may de 2019

Check memory/CPU usage

1