Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Sybase Performance and Tuning for Database Administrators
Sybase Training Overview:

The Sybase Performance and Tuning for database administrators class provides the students with a detailed understanding of the methods that can be used to provide for the most effective performance of their Sybase relational database management systems. Students will be presented with numerous step by step procedures to implement in order to obtain the most efficient processing of the Sybase server. The Sybase database administrators will also be shown how they can work with their developers to help generate the most effective Sybase code.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to implement numerous tuning and performance factors that will provide them with a highly tuned Sybase server.

Sybase Training Prerequisites:

Students should have at least 3 months experience as an Sybase database administrator. A knowledge of Sybase programming is useful, but not required.

Sybase Training Audience:

This course is specifically recommended for database administrators who require an in-depth understanding of the means by which to tune their Sybase servers.

Course duration:

4 days

Sybase Training Course outline

Architectural overview of Sybase
  • Pages
  • Devices
  • Networking
  • Interfaces file
  • Errorlog file
Logical versus Physical Devices
  • Performance Implications
  • Raw versus Filesystem
  • Dsync option
Sybase Mirroring
  • RAID
  • Volume Management
System Information
  • System Tables
  • System procedures
Performance considerations for creating and sizing databases

Performance considerations for creating and sizing logs

Database options for maximizing performance

Transaction processing
  • Transaction logging
  • Checkpoints
  • Recovery processing
  • Suspending transactions
Resource Management Performance
  • Enabling resource limits
  • Enforcements
  • Actions
Utilizing the Logical Process Manager for performance
  • Logical process manager procedures
  • Engine groups
Tuning Memory Management
  • Configure, tune, and size data, procedure, and partitioned caches
  • Providing named cache
  • Buffer pools
  • Wash area
  • Binding objects to cache
Locking Principles
  • Data-Only Locking Tables and Table Fragmentation
Performance Monitoring
  • Use sp_sysmon and other utilities to tune the server for performance gains
  • Activity monitoring
  • Dbcc commands
  • Space utilization
  • Improve performance of tempdb by sizing, placement, and solving locking
Parallel Concepts
  • Parallel Tuning
Tools
  • Bcp
  • Denfcopy
  • Optdiag
  • Sybase Central
Working with developers
  • Finding problems in coding
  • Index usage
  • Data distribution statistics
  • Use statistics to manage space on DOL tables and indexes
  • Choose the appropriate table locking scheme for a given application
  • Internal methods of join processing
  • Optimizer hints
  • Stored procedure processing
  • Abstract Plans
  • Partitioning methods and performance implications
  • Identify and correct problems in database physical design, including table partitions



 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy