i want to create a report with number of queries running in the different categories i.e adhoc short,long,tactical etc.
We find this classification in the 'Workload' column in the viewpoint.
which dbc table or viewpoint option can i use to create this report. I can get the query info from from
tables and querry logging is enabled.
Its little urgent, so early reply is highly apprciated