Identifying killer queries in viewpoint
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.
Getting ready
You need to log in to Teradata viewpoint and enable query monitoring and the query spotlight portlet.
How to do it...
- Log in to Teradata viewpoint using your credentials.
- Go to the query monitor portlet. All the live queries on the system can be seen here.
- To identify currently...
