Hello all,

I am administering a datawarehouse and management would like to know what sort of queries people are running, how they perform and the effect or impact they would have on overal performance. I am a bit stuck on how to tackle this problem. My guess is, I could use the built in auditing features and create some triggers to gather the information I need. Would this be the right approach or does anyone have some other sollution?