Identify slow queries
Slow queries are SQL database queries made by application code that take an unusually long time to execute. An increase in slow queries will reduce the efficiency and resiliency of an application’s database. A site with frequent slow queries might appear to operate well under normal amounts of traffic, but can perform poorly if the amount of traffic increases even by small amounts.