While general system level and use metrics are captured in ResUsage tables or Teradata’s Database Query Logs (DBQL), there is a way to gain a more complete and holistic understanding of data warehouse performance through the installation of Teradata’s Performance Data Collection and Reporting (PDCR) database.
Teradata Professional Services teams offer expert installation of the PDCR database through a three week services engagement. Once installed, this specialized database captures system performance and offers diagnostic reports and graphs to help you tune applications, monitor performance, develop capacity plans and operate your Teradata system at peak efficiency. In effect, the Performance Data Collection and Reporting engagement helps lay the groundwork for effective systems management.
Also as part of the engagement, our teams help mentor your staff on data collection and leading practices for reporting and interpreting performance data.
Features
- Performance data collection and reporting database which includes a toolkit and new summary tables in the latest release
- More than 80 views, macros and reports to help scrutinize data warehouse performance
- Reports included for capacity planning, system performance, workload management, and database space management
Benefits
- Gain and understand the right information to tune data warehouse applications Capture performance data in a single repository
- Identify capacity trends to avoid running out of system resources
- Utilize expert help and mentoring on data warehouse performance best practices
- Become more pro-active in data warehouse performance
