Query Supervisor gives you the ability to not only monitor for expensive and runaway queries, but to take action while the query is running.
By Sarah Mackenzie
Identifying and managing long-running and resource-intensive queries can be challenging. You can try to identify and fix these queries before they are used in your production environment, but this is not always possible. For example, you may have a user perform a long-running ad hoc query that consumes a lot of resources, or you may have a query suddenly take longer to complete than usual. It is important to be able to detect these long-running, resource-intensive queries so that you can achieve improved systems management. Read More
Get empowered with IBM Power
