Pergunta de entrevista da empresa Tata Consultancy Services

How do you diagnose slow query performance

Respostas da entrevista

Sigiloso

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

Sigiloso

22 de mai. de 2019

Check memory/CPU usage

1