loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Sybase PT course

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Ahana Systems

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Sybase PT course

Banashankari, Bangalore

No Reviews Yet
0 Interested

About the Course


We are a “IT Infrastructure Training & Service organization” endowed with providing technical trainings for today’s challenging environment

Topics Covered


Performance and Tuning: Configuring Adaptive Server Enterprise

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

Who should attend

Any DBA Can join for this training

Pre-requisites

Basic SQL or Linux

What you need to bring

We will provide you the required stuff

Key Takeaways

Sybase PT
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


C. K. Chidananda Murthy brings with him a rich experience of 14 years in the training field.
Associated with AHANA SYSTEMS AND SOLUTIONS since 2008 as a Technical Trainer.
Seats Left-

Students Interested 0

Course Id: 17684