SYSTEM, METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS
Publication Date: 2010-Mar-09
The IP.com Prior Art Database
System and methodology for autonomic tuning tools and advisors integration and interaction for SQL performance tuning in an RDBMS. We already had theory and methodology to SQL performance by individual tuning tools and design advisors. A DBA or an application developer needs to determine what's the root cause of the problematic SQL by referring to tuning tools or design advisors separately. Actually, we could give them a better view if we combined all the results together. For example, for a particular table's access path, if a relational scan is suspicious by an access path advisor, as well as no statistics detected by statistics advisor. Currently, we don't have such a mechanism to build the connection between them. Patents: Automatic SQL tuning advisor (http://www.google.com/patents?id=RbWWAAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false) Method, system, and program for performance tuning a database query (http://www.google.com/patents?id=9y59AAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false) SQL tuning base (http://www.google.com/patents?id=nICWAAAAEBAJ&zoom=4&pg=PA1#v=onepage&q=&f=false)
,,, METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORSMETHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORSMETHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS
METHOD FOR AUTONOMIC INTEGRATED SQL TUNING TOOLS AND ADVISORS
A. The currently work flow and methodology to tuning a SQL performance by using individual tuning tools and design advisors , they will be executed one by one separately , DBA or application developer still needs additional deep skills or extra effort to analyze a SQL performance problem .
B. Actually these design advisors could be integrated for better and higher confident advisors' advice. Tuning tools can be interacted with each other and all the design advisors for better SQL analysis view .
C. Some foreseeing implementations by this disclosure :
Advisors integration: suppose we have a suspicious table in a problematic SQL , the statistics advisor reports statistics missing in this table , and the access path advisor reports tablespace scan is chosen as table access , at the same time, since we have a stage 2 predicate causes existing indexes can 't be chosen. Actually, we could integrate all the information and tell what might be the root cause and what action to take .
Tuning tools interaction : when a SQL element is selected , all the other components highlight related information at the same time . We won't have separ...