Unfortunately i have not got the luxury of using external tools as I'm trying to use whatever is available within SQL Server itself. Would querying sysperfinfo every few minutes solve...
Thanks Kay.. i too am aware of this solution (VB Macro Keystrokes) as it was something i have seen practiced in a company. However there must be a more elegant...