Performance and Tuning: Configuring Adaptive Server Enterprise 15.7 - EDB553

All Levels

Created by Ram Niwas Sangwan Last Updated 14/09/2023 09:01

₹7,999.00 ₹9,999.00 20.00% off

What's Included

  • 7 Lectures
  • Access on tablet and phone
  • Certificate of completion

Course Curriculum

Expand all Collapse all

7 Lectures

00:00

Device and Disk Optimization 0 Lectures
Parallelism, Logical Process Manager and BCP 0 Lectures

Description

Performance and Tuning Configuring Adaptive Server Enterprise 15.7

(EDB553)

Goals

  • Discuss tradeoffs involved in performance tuning
  • Use sp_sysmon and other utilities to tune the server for performance gains
  • Properly configure memory for optimal performance
  • Manage multiple engines
  • Configure, tune, and size data, procedure, and partitioned caches
  • Identify and correct problems in database physical design, including table partitions
  • Use statistics to manage space on DOL tables and indexes
  • Choose the appropriate table locking scheme for a given application
  • Reconfigure Adaptive Server dynamically
  • Improve performance of tempdb by sizing, placement, and solving locking

Audience

  • Database Administrators
  • Open Interface Developers

Prerequisites

  • Fast Track to Adaptive Server Enterprise 15.0/16.0
  • System and Database Administration: Adaptive Server Enterprise or equivalent work experience to Fast Track and System and Database Administration.

Instructors

RN

(4.45)

21 Courses

200 Students

2809 Reviews

Ram Niwas Sangwan
I have spent 30 years in IT Industry as an Educationist. I have been a software developer/corporate trainer and an information systems specialist with a record of developing and supporting solutions incorporating a wide range of applications. I have an entrepreneurial-mindset and a track record of success in recognizing opportunities spanning more than 26 years. Developing innovative and creative approaches, I have trained top level executives of companies driving revenue growth and enhancing long-term profitability. I have been motivating my team to ensure project success and on-time delivery. I, have time and again proven my ability at managing multiple priorities in fast-paced environments.
Businessman Leading a team of Professionals in the Area of Software Development with more than 1200 Satisfied Client. Currently I am managing www.theskillpedia.com and www.skillpedia.ai