Teradata System Optimization Services (SOS) provides a convenience, cost-effective option for addressing the gap between maintanance. An annual or biannual evaluation consists of evaluating key system settings and dynamic trands. Technicians who perform the evaluation are experts in identifying and addressing sub-optioned conditions and performance issues.
The holistic approach reveals performance issues that span mutiple user groups, tables, applications and queries. The audit, analysis and tuning are conducted from both a "technology" and an "activity" standpoint. SOS is focused on:
1) Teradata Tools and Utilities
2) System Management Procedures
3) Teradata Database (software)
4) Operating Sytem/Firmware
5) Platform (hardware)
Based on the results of these specific data collections and comprehensive analysis, system adjustments are performed and recommendations for additional consideration and tallied.
Annual engagement to prevent performance issues and maintain optimal performance are an ideal way to free your DBAs to focus on strategic projects or to receive periodic access to a senior Teradata consultant. Annual or Biannual SOS's can be scheduled to prepare your system for recurring high or critical usage periods.