ASE 15 Migration for DBAs
- Type product
ASE 15 Migration for DBAs
Opleiderscore:
Beschrijving
Goals
- Determine changes that need to be made to the ASE 15.0.3 server
- Understand optimization in ASE 15.0.x from the perspective of the * Database Administrator
- Explain new optimization tools and their usage
- Take advantage of new options to configure the Optimizer
- Contribute to faster, more efficient code
- Utilize MDA tables for monitoring server performance
- Tune Procedure and Statement caches
- Understand new tempdb functionalities
- Make configuration changes that will improve your 15.0.3 server performance
Audience
- Database Administrators
- Sybase System Administrators
- SQL Developers who want to understand changes in ASE 15.0.3 impacting their SQL development
Prerequisites
Essential- * Fast …
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Goals
- Determine changes that need to be made to the ASE 15.0.3 server
- Understand optimization in ASE 15.0.x from the perspective of the * Database Administrator
- Explain new optimization tools and their usage
- Take advantage of new options to configure the Optimizer
- Contribute to faster, more efficient code
- Utilize MDA tables for monitoring server performance
- Tune Procedure and Statement caches
- Understand new tempdb functionalities
- Make configuration changes that will improve your 15.0.3 server performance
Audience
- Database Administrators
- Sybase System Administrators
- SQL Developers who want to understand changes in ASE 15.0.3 impacting their SQL development
Prerequisites
Essential- * Fast Track to Adaptive Server Enterprise (EDB115) * System and Database Administration: Adaptive Server Enterprise (EDB356)
Content
- New Functionalities in ASE 15.x
- Database Changes
- Configuration Parameter Changes
- Access Methods for Queries and Data Modification
- Costs and Benefits of Indexes
- Query Optimizer
- Statistics
- Optimization
- Joins and Join Types
- Parallel Queries
- Stored Procedure Compilation and Performance
- New Index and Partitioning Behavior
- Metrics, MDA Monitoring, and QPTune
- Compatibility Mode
Notes
- 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.
Popular tags
No tags submitted for this course yet
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.