Explore the Adaptive Server Enterprise 15.0.3 server environment from a database administration perspective before and after a migration. Also, discover critical changes and enhanced functionalities that are now used governing server behavior. Take advantage of the monitoring and evaluation tools of Adaptive Server Enterprise 15; interpret their diagnoses into specific plans of action; and perform tasks to evaluate and modify the behavior of the optimizer to improve SQL code performance, so as to implement the most efficient data-change and data- retrieval T-SQL code in queries and stored procedures.
Understand how to more efficiently work with the statistics used by the new optimizer and make changes to existing methodologies for generating them. Understand and work with the MDA tables to more clearly understand, monitor and tune Procedure and Statement caches.