sybase - performance and tuning: configuring adaptive server

ahana systems and solutions (p) ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: umashankar

Course Description:

'' sybase database administration

performance and tuning: configuring adaptive server enterprise
course topics:

module 1: principles of performance and tuning
performance and tuning defined
design and tuning principles
performance diagnostics and tuning methodology
case study discussion
module 2: architectural overview
adaptive server architecture
performing tasks in ase
logical page size
module 3: the tuning toolbox
tools and utilities
set commands
system procedures
monitoring5?s
focus on a?sysmon
module 4: locking principles
locking concepts
configuring locks
deadlock
reducing contention
module 5: managing5? fragmentation
fragmentation overview
assessing5? fragmentation
minimizing fragmentation
defragmenting5?s
module 6: working with multiple engines
multiple engine concepts
configuring multiple engines
spinlocks overview
user log cache spinlocks
module 7: named cache configuration
concepts review
configuring named caches
troubleshooting and monitoring
module 8: large i/o configuration and tuning
configuring large i/0
tuning large i/o
configuring metadata caches
module 9: cache strategies and cache partitioning
fetch and discard
relaxed lru
async prefetch
cache partitioning
module 10: procedure cache and statement cache
tuning
how the procedure cache works
sizing the procedure cache appropriately
troubleshooting procedure cache problems
statement cache
module 11: optimizing device usage
the i/o subsystem
review of devices and segments
tuning and troubleshooting i/o problems
tempdb sizing and placement
tuning tempdb problems
module 12:5? partitioning
table partitioning overview
partitioning5?s and indexes
table partitions and performance
controlling data placement
guidelines for tuning
module 13: optimizer statistics
how optimizer statistics are stored
viewing optimizer statistics with optdiag
managing optimizer statistics
tuning and troubleshooting
upgrade issues
module 14: parallel concepts
parallel access overview
enabling parallel access
monitoring parallel access
module 15: parallel tuning
parallel sort overview
configuring parallel sort
tuning and troubleshooting
semantic partitioning and parallel sort
module 16: tuning with the logical process manager
implementing logical process manager
engine groups and performance
priority queues and execution classes
binding objects and precedence
reporting tools, modifications and usage
case study
module 17: tuning bcp
mass data transfer concepts
configuring for performance



...''

Elements of this syllabus are subject to change.

Phone:+91 80 26675891

School Address/Venue(s):

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ��?560050



Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for sybase - performance and tuning: configuring adaptive server training resources.

sybase - fast track to adaptive server enterprise
sybase - system and database administration: adaptive server enterprise
sybase - mastering advanced t-sql
sybase replication
SQL Server 2005: Integration Services
sql server 2005: reporting services
Perl
Shell Scripting
VMWARE ESX Administration
Linux System Administration (Based on RedHat)

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.