sybase configuring adaptive server

ahana systems and solutions pvt 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? partitioning5? partitioning overview
* partitioning5?s and indexes
*5? 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: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for sybase configuring adaptive server training resources.

oracle database administration
oracle 10g database administration
oracle 10g rac
sybase database administration
fast track to adaptive server enterprise
sybase t-sql
mysql database administration
Perl Script
Shell Script
ClearCase Administration
Linux System Administration (Based on RedHat)
VMWARE ESX Administration

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.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.