Calgary - Edmonton - Halifax - Mississauga - Montreal - Ottawa - Toronto - Vancouver - Victoria - Winnipeg

ASE training courses and schools
HP Accredited Sytems Engineer

School: Sybase Canada Ltd.
[All Courses]

Interpreting SP_SYSMON
Course Format: Classroom
Understand this site critical report and how best to use its information. Gain an overall view of the different reports that are generated by SP_SYSMON. Get a line-by-line analysis of what the eighteen reports are; when and how often they should be run and what each report provides. Each of the SP_SYSMON reports will be covered. Recommendations will be provided on which reports should be focuse...
 

Administering Sybase IQ for the Data Warehouse
Course Format: Classroom
Acquire a working knowledge of Sybase IQ through a combination of lecture presentation and hands-on laboratory exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, loading, and maintaining a Sybase IQ database. Course material also covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the performance and t...
 

Unix to Linux Migration for Adaptive Server Enterprise
Course Format: Classroom
Linux is quickly becoming a mainstream operating system for businesses requiring the stability and reliability of Unix with the additional benefits of lower IT infrastructure and computing costs. Sybase has responded to this trend by certifying and supporting its products on Linux, including Sybase Adaptive Server Enterprise. This training course will show you how to assess an existing Unix or ...
 

Implementing ASE Replicator
Course Format: Classroom
Introduce the new Sybase ASE 12.5.0.1 feature ASE Replicator. Walk through the process of setting up ASE Replicator, discuss it use and limitations. Additionally, basic troubleshooting hints are covered. Who Should Attend Sybase Database Administrator’s who are planning on implementing ASE Replicator Topics Review of Replication techniques Implementing ASE Repl...
 

Interpreting the Major ASE System Tables
Course Format: Classroom
This course will teach ASE administrators how to read and interpret information found with the ASE system tables . Who Should Attend Database Administrators Objectives Upon completion of this course, you will be able to: Identify all major ASE System Tables Understand the function and relationship between key ASE system tables Customize existing sp_¡¯s Write...
 

Dynamic Reconfiguration for Managing Memory Nonstop Optimal Performance
Course Format: Classroom
Learn how memory is allocated in Adaptive Server Enterprise (ASE) 12.5 and how to use Dynamic Reconfiguration (the ability to change ASE without rebooting) to provide optimal use of available resources. Understand troubleshooting memory resource and performance issues, which configuration parameters can be reset without needing to restart ASE, analyzing the impact of dynamically changing config...
 

Using Abstract Query Plans
Course Format: Classroom
Learn to write partial or complete abstract query plans, understand how to tune the optimizer and 3rd party applications. This ensures that the quickest access path method can be used every time. Writing your own plan will help the system to be fully optimized whenever retrieving data. You can force the optimizer to use the proper access route even if the statistics are updated and accurate. Ab...
 

Managing and Tuning tempdb
Course Format: Classroom
Covers tempdb performance issues and introduces the new feature of Adaptive Server Enterprise (ASE) 12.5.0.3 that allows you to create multiple tempdbs on ASE 12.5.0.3 servers. Discusses the rational behind implementing this option, steps needed to create or delete a user created tempdb, how to create and manage tempdb groups, and new stored procedure sp_tempdb with related global variables. ...
 

Powering Up with ASE 12.5.2
Course Format: Classroom
Gain hands-on experience with the new features of Adaptive Server Enterprise (ASE) version 12.5.2. If you are upgrading from ASE versions 12.5.0.3 and/or 12.5.1, the latest features in version 12.5.2 make ASE even easier to deploy and maintain with enhanced operational scalability to support tougher workloads with fewer resources. ASE 12.5.2 ensures highest operational efficiency and throughput...
 

Powering Up with Adaptive Server Enterprise 12.5
Course Format: Classroom
Get hands-on experience with the new features of Adaptive Server Enterprise (ASE) 12.5 and Interim Release 12.5.0.1. Learn what the new features are and how to use them, study new and modified commands and troubleshooting tips, and gain valuable insight on fine-tuning considerations and upgrade issues. Course Objectives : Upon completion of this course, you will be able to: Describe the in...
 

Page(s):- ...5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 [ Popular Topics ]