Performance and Tuning: Configuring Adaptive Server Enterprise 15.7 - EDB553

All Levels

Created by Ram Niwas Sangwan Last Updated 11/05/2021 13:43

₹7,999.00 ₹9,999.00 20.00% off

What's Included

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


Performance and Tuning Configuring Adaptive Server Enterprise 15.7



  • 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


  • Database Administrators
  • Open Interface Developers


  • 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.



19 Courses

228 Students

2 Reviews