Advanced Teradata DBA Services
Having managed one of the UK's largest and busiest Teradata Data Warehouses, TeraTeam UK resources possess a deep understanding of issues surrounding all aspects of Performance and Capacity Management, from Loading using Teradata Utilities and ETL Tools to reducing unnecessary repeated SQL as well as fine tuning code to limit the impact of poor queries. We can, therefore, deliver to your company the following advanced DBA services to a World Class standard.
Tasks Include:-
Teradata Performance Monitoring
- Using Teradata Manager to monitor, report and, where necessary, intervene to ensure both production and business users receive optimum performance from your Teradata system(s).
In addition to this standard service, TeraTeam UK can offer their extensive experience in the development of bespoke Alerting and Reporting tools to assist in performing this role. More…
Teradata Server Management
- Monitoring of overall server performance from a Teradata software or hardware standpoint.
- Liaising directly with Teradata to ensure that any issues or problems are reported and resolved.
Teradata Upgrade Management
- Planning, implementing and testing all hardware and software upgrades or fixes, and compiling and reporting associated metrics.
Teradata Performance Tuning
- Optimising CPU and IO resource utilisation through
- SQL tuning using extensive knowledge of DBQL and ‘explain plan’ analysis to identify poor patterns of usage and inefficient/incorrect code.
- Amending rules within the **Teradata Active Systems Management (TASM) tool set appropriate to your operating system.
- Assisting/advising your developers in efficient SQL production to ensure optimum performance from your Teradata Platforms.
We have extensive experience in the analysis and implementation of TASM.
Teradata Capacity Management
- Analysing, forecasting and reporting your Teradata system’s capacity from both a space and CPU utilisation perspective.
TeraTeam UK has experience in the design and implementation of both the Teradata proprietary capacity management tool, as well as bespoke solutions. More…
Incident Management
- Identifying repeating incidents and resolving through root cause analysis.
- Providing ‘out of hours’ incident resolution and reporting.
