Properties Dialog Box - Query Log Tab

Return to: Properties dialog box

Other tabs: General, Environment, Processing, Add-Ins.

The Query Log tab enables you to change the settings for the automatic logging of queries performed by Microsoft® SQL Server™ OLAP Services.

The Usage-Based Optimization wizard and Usage Analysis wizard rely on the query log. Options in this tab affect the output of these wizards.

Options

Sample frequency (once per)

Controls the frequency of query logging. By default, every tenth query is logged. You can turn off query logging altogether or change the frequency.

Note Setting this option too low may adversely affect performance.

Default: 10 (1 in 10 queries is logged).

Valid range: 1-10,000.

To enable query logging and specify the frequency

1. Check Sample frequency (once per).
2. In the Queries box, specify the interval between each log entry. A value of x results in the logging of every x^th query. For example, a value of 20 results in the logging of every 20th query. Only integers are valid.
3. Click OK.

Clear entire log

Deletes the contents of the query log.

Consider clearing the query log after you run the Usage-Based Optimization wizard consecutively on all cubes on the server.

To clear the query log

• Click Clear entire log, and then click OK.

See Also

Optimizing Performance Based on Usage in the Administrator’s Guide

Usage-Based Optimization Wizard in the Administrator’s Reference

Analyzing Usage Patterns in the Administrator’s Guide

Usage Analysis Wizard in the Administrator’s Reference