I just wanted to know how can I monitor queries currently running in my Database which are eating up resources i.e. CPU etc..?
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..?
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.