The Database Query Log (DBQL) stores historical records of queries, together with their duration, performance, and target activity, based on rules you define.
- In the Data Source Explorer, right-click a database or user, and click The Query Logging Rules dialog opens.
- Click the Display Query Logging tab.
- From the Rule Type options, choose the application or users for which you want to display query log rules. Applications or users that have associated query logging rules defined are displayed in box.
- Select the application or database users for which you want to display query logging rules (you can select more than one), and click Display. Query logging rules that have been defined for the selected application or users are displayed in the Logging Rules table.