With thousands and millions of queries coming in and out of the Teradata system, it is important to find high-impact queries. Teradata provides various tools for query and workload management so that the system works at optimal performance.
We can use system tables like resusage
and pdcrinfo
to get the poorly performing user queries, which could be high CPU, I/O, and skewness. These could also be monitored in real time by using a GUI interface called viewpoint. You can also go back in time and check for the queries that have caused an adverse impact on the system.
In this recipe, we will use viewpoint to identify high impact or killer queries on your Teradata platform.
You need to log in to Teradata viewpoint and enable query monitoring and the query spotlight portlet.