performaernce and tuning: configuring adaptive server enterprise

ahana systems & solutions (p) ltd.
hanumanth nagar, karnataka, india

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

Course Description:

'' 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

monitoring tables

focus on a?sysmon

module 4: locking principles

locking concepts

configuring locks

deadlock

reducing contention

module 5: managing table fragmentation

fragmentation overview

assessing table fragmentation

minimizing fragmentation

defragmenting tables

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: table partitioning

table partitioning overview

partitioning tables 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:080-26675891

School Address/Venue(s):

ahana systems & solutions (p) ltd.

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

Jobs & Resumes: hanumanth nagar
Houses & Roommates: hanumanth nagar

Search other schools for performaernce and tuning: configuring adaptive server enterprise training resources.

Oracle 10g RAC
Oracle DataGaurd
Oracle 11i Application DBA
Fast Track to Replication Server Administration
system and database administration: adaptive server enterprise
MySQL for DBA’,s

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: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.