Sollicitatievraag bij Tata Consultancy Services

How do you diagnose slow query performance

Antwoorden op sollicitatievragen

Anoniem

20 aug 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

Anoniem

22 mei 2019

Check memory/CPU usage

1