AGS S1 E7 HD - SQL Statement Capture

Sometimes the single biggest reason for slow performance is the most obvious: missing indexes. This will cause unnecessary sequential scanning, and the best way of working out what additional indexes are needed is to record a sample of SQL statements over a few days. AGS Sentinel (a service that runs in background) can easily be programmed to capture SQL statements involving sequential scans with a high optimizer cost, for subsequent production of a league table of the worst and/or most frequent such queries. The developers can then decide whether to alter the statement, add optimizer directives or add an index.

Go back to videos