Query to get most expensive query running/historical without/with using DBQL..?

Database
Enthusiast

Query to get most expensive query running/historical without/with using DBQL..?

Hi,

I just wanted to know how can I monitor queries currently running in my Database which are eating up resources i.e. CPU etc..?

2 REPLIES
Enthusiast

Re: Query to get most expensive query running/historical without/with using DBQL..?

Is it always required to login to viewpoint to monitor queries which are expensive; For historical queries I can check in DBQL but what to do for current running..?

Teradata Employee

Re: Query to get most expensive query running/historical without/with using DBQL..?

You can potentially call the same PM/API functions that Viewpoint does. See the manual titled "Application Programming Reference".

Be aware that having many users issuing these API calls can cause contention; that was one of the original reasons for Viewpoint - make only one set of monitoring requests to the database every so often, and let many users view the subsets of information they are interested in via web portal.