Ward Analytics – Teradata Performance Tuning
Ward Analytics is the global leader for Teradata performance tuning, analysis and management solutions and services to the global Teradata customer base. For enterprises, who have invested in Teradata as the core of their enterprise data warehouse environment, and need to ensure that their investment is leveraged as fully as possible, Ward’s suite of performance tuning, analysis and management tools and services provides the perfect solution.
Teradata Performance Tuning Products
To address the different aspects of Teradata Performance Tuning, Ward provides a range of software products specifically designed for Teradata, with features and functionality targeted at all of the key areas that experience shows can be analysed and optimised.
- Visual Edge – Investigate analyse and tune Teradata performance.
- Prism – Query tuning, analysis and optimization.
- Active Workload Manager – Workload management.
- System History Scripts – a free tool for managing all performance data.
PaaS – Teradata Performance Tuning as a Service
Based on Ward’s best-in-class Visual Edge analysis tool suite and a mixture of proprietary and standard performance data, the PaaS Performance Tuning services are delivered on an as-required basis via the cloud, and covers all aspects of the Teradata platform. Analysis is carried out by highly field-experienced Teradata Masters.
Performance data is uploaded to Ward’s secure Cloud servers, and the performance analysis reports and outputs are delivered back via the same mechanism.
Taming the Beast
Teradata is a powerful platform, and with that power comes a degree of sophistication and complexity that is inevitable; Ward’s solutions and services are specifically targeted at Teradata customers who want to ensure optimal performance at every stage of the Performance Life-cycle.
Designed and built with the accumulated field-based knowledge that comes from significant practical hands-on experience of some the world’s largest Teradata implementations, Ward’s solutions implement and deliver Teradata best-practice wherever it has been defined (by Teradata, Ward or other independent and highly regarded practitioners). We provide solutions and services to analyse and manage the Teradata database, Queries & Workloads and the underlying server platforms.
Ward’s customer base is global, reflecting Teradata’s worldwide user community, and we support enterprises in all industry sectors.
Performance Central, Ward’s Teradata performance BI platform brings together all of the data necessary to provide you with a complete and integrated view of the performance of the datawarehouse.
All of the potential roles for Performance Central users are catered for; Operational, Executive, Line of Business, Development, Power Users, Analyst, DBA etc. Potentially every stakeholder has access to a web-based environment, with one-click query access to critical EDW KPI’s, views of non-Teradata data integrated with Teradata performance metrics.
Unique views of the EDW are available including Capacity Modelling, Resource Usage supporting Charge-back calculations, Instant Reports, SLG’s and SLA’s, TASM reports and all metrics (where possible) are viewable by the User’s Line-of-Business/Business Group.
Performance Tuning Life-Cycle
Teradata Performance Tuning & the Performance Life-Cycle
Data warehouse performance management is not a one-off isolated activity; it is a continuous cycle of:
- Setting objectives
- Gathering data
- Analysing the data
- Actions based on the Analysis
- Reviewing the results of the actions and restarting the cycle
Product Suite to Support the Performance Life Cycle
Ward’s software tools support the Performance Lifecycle, and are designed to provide maximum value to Teradata EDW’s. Examples include;
- Performance degradations & missed SLA’s.
- Random performance hits.
- Poorly performing queries
- Application performance issues.
- Real-time Workload performance.