Teradata Performance Management - Locus IT Services

Teradata Performance Management

Locus IT ServicesPerformance ManagementTeradata Performance Management

Teradata Performance Management

Teradata Performance Management recognizes that your data warehouse must handle complex analytics and tactical data queries that drive day-to-day operations. You should require the ability to manage mixed workloads – including supporting rapid tactical data queries and complex strategic analytics while prioritizing and applying appropriate resources to each. Fortunately, the Teradata advanced performance tools and services give you maximum power and flexibility for analytics of Teradata Performance Management.
The Teradata Performance Management of systems means the management of system resources, such as CPU, the I/O subsystem, memory, BYNET traffic, host network traffic. Since Teradata Database is a parallel processing system, it is highly dependent upon balanced parallel processing for maximum throughput. Any any point the system becomes skewed, the throughput of the system is reduced.

Teradata Performance Management Database

Data should be collected by time initially and then by workload. Teradata recommends the following categories:

  • Workload utilization as recorded in DBC.AMPUsage view and as summarized in DBCMNGR.LogAMPUsage
  • Disk consumption as recorded in DBCMNGR.LogPerm and DBCMNGR.LogSpool
  • User counts as recorded in DBCMNGR.UserCounts
  • Heartbeat query response times as recorded in DBCMNGR.LogHeartbeat
  • Throughput, response times, captured SQL details as recorded in DBQL and summarized in DBCMNGR.LogDBQL
  • System utilization as recorded in the ResUsage views and summarized in DBCMNGR.LogResUsage

Teradata Performance Services

  • Workload Management
  • Application Performance
  • Performance Data Analytics
  • Capacity Management services

Features and Benefits

  • Optimize and Manage

Professional Service Consultants who can optimize and manage end-to-end analytics of environments for higher efficiency and utilization.

  • Forecast Performance Trends

Effectively plan and forecast the data platform resources to meet demands that drive business value.

  • Workload Management

Review system resources, identify the workloads, assess requirements, and establish prioritization and workload controls to meet the processing SLAs.

  • Application Performance

Maximize a Teradata system with the Teradata Professional Services consultants working alongside DBAs to target problem areas and fine-tune applications to reduce resource consumption.

  • Capacity Management

Clarify and predict organic and the new application consumption requirements across multiple system resources on production, QA, and test environments.

Provide multiple methods for analyzing platform performance trends and then identifying when performance management actions are needed to avoid response time challenges.

Standard System Performance Reports

There are several kinds of Teradata Performance report for systems that are helpful in collecting performance data. These Teradata Performance report look at:

  • Weekly trends, which establish ongoing visibility of system performance.
  • Specific kinds of trends, including exception-based reporting
  • Standardized report and view help facilitate coordination

Standard System Performance Alerts

Setting standard system alerts, particularly the alerts that Teradata Manager provides through its alerts/events management feature establishes performance thresholds that make responding to performance anomalies possible.
Teradata Manager alerts or events management feature can automatically activate such actions as sending a page, sending e-mail, or sending a message to a Simple Network Management Protocol (SNMP) system.
Other applications and the utility programs can also use the Alert function by using a built-in request interface.

  • The Alert Policy Editor is the interface that defines actions and specifies when they should be taken based on thresholds you can set for Teradata Performance Management parameters, database space utilization, and messages in the database Event Log.
  • The Alert Viewer allows to see system status for multiple systems.

Locus IT has worked with BI industries that utilize Teradata products and has provided unique solutions to their requirements. We also provide Teradata product implementation, training and support. For more information please contact us.

Locus IT Project Management Office
What’s it?