Alerting & Reporting Tools
In order to provide as much useful information to both the DBA and Management teams, TeraTeam UK resources are highly proficient in the design, and build and implementation of Alerting and reporting tools such as those shown below.
Transient Journal Space Warnings
It is imperative that your system has sufficient Transient Journal space available in order to perform such tasks as rollbacks on insert or update query failure. This space may be compromised when, for example, a user mistakenly submits an INSERT SELECT statement on a significantly large populated table. TeraTeam UK can provide a bespoke alerting tool to alert your DBA team of this potential issue.
AWT Usage
AMP Worker Tasks (AWTs) are an essential resource within the Teradata operating system, and can, in busy environments, become over subscribed, causing your system to be stretched and thus, your workload(s) to be delayed. We are able to provide alerting mechanisms to inform your DBA team of impending issues.
'Bad' Query Alerts
SQL Queries can cause your system to grind to a halt or use excessive amounts of CPU. Working in one of the busiest warehouses in the UK has encouraged TeraTeam UK DBAs to devise various methods of alerting and reporting both 'bad' queries and those executing eccessive repeated SQL statements such as multiple table inserts.
Security Reporting
It is, of course, essential that data is viewed only by those users who have permission to do so and that this security process is monitored and audited. We are experienced in providing tools that can report on Role usage and unusual or sensitive data access.
