Logging Tab (Properties Dialog Box)
Use this tab to change the settings for the automatic logging of queries performed by Microsoft® SQL Server™ 2000 Analysis Services and the automatic logging of processing messages.
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
Log queries sent to server
Select to enable query logging.
- Write to log once per __ queries
Specify the frequency of query logging. By default, every tenth query is logged. You can turn off query logging altogether or change the frequency.
Important Setting this option too low may adversely affect performance. Only integers are valid for this setting.
Default: 10 (1 in 10 queries is logged).
Valid range: 1-10,000.
Clear log
Select to delete 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 log, and then click Yes.
Log processing messages to a file
Select to enable the logging of processing messages to a log file (.log).
- File path and name
Type a path and a name for the log file. UNC paths are recommended.
- Browse
Click to display the Open dialog box, where you can select a path and specify a file name for the File path and name box.