Tags for query spotlight
Killer queries: Track them, find them, fix them
With increased workload complexity, it is common for a system to run in full capacity. There is always a need to find resource consuming sessions and bad running queries. The intention of this article is to discuss a few ways to identify resource consuming sessions or bad running queries using Teradata Viewpoint.
viewpoint query monitor query spotlight resource usage v_viewpoint
Query Pinspot: Query Spotlight + Query Group Functionality
Query Groups are great for allowing BI Tool admins to monitor tool specific sessions that are currently active and rewind to go back in time. However, Query Spotlight is a great tool to spotlight sessions that may have been TASM aborted because of excessive Spool or CPU consumption.
viewpoint portlets query groups query spotlight