Database Performance Made Easy Through Graphics
Average Active Sessions (AAS) Formulas, Interpreting Load Charts and Visual SQL Tuning (VST)
Kyle begins his presentation with a discussion of the use of sample data to create Active Sessions History (ASH). But ASH is dense, multidimensional data, which makes it difficult to analyze. Fortunately, ASH can be simplified using a metric called Average Active Sessions (AAS). AAS shows the load on the database and allows you to drill down with precision and clarity into the cause of each bottleneck.
Most often, bottlenecks are caused by poor-performing SQL statements. For analyzing suboptimal SQL statements, Kyle will show you how to lay out the query graphically in a Visual SQL Tuning (VST) diagram. Through the VST, you’ll learn how to quickly visualize any coding errors in the query, discover flaws in the underlying database schema, and most importantly, find the best execution path through the query.
No comments:
Post a Comment