Configuring the Analysis Services Query Log

SQL Server Analysis Services uses query logs to log statistical information about queries.

SQL Server Analysis Services 2005 continues to store information about queries in a relational database. This information is used in Usage-Based Analysis.

There are only a few differences between Analysis Services in Microsoft® SQL Server™ 2000 and Analysis Services in SQL Server 2005. However, these differences are quite important. Following is a brief description of each of these important differences.

• By default, Analysis Services 2005 does not log queries into the query log table. To log queries, you need to adjust Analysis Services properties.
• Analysis Services 2005 does not support Microsoft Office Access databases as a hosting technology for the query log table. You must point Analysis Services to the SQL Server database if you want a to create a query log table and log queries.
• SQL Server does not have to reside on the same computer as Analysis Services.
• Analysis Services no longer uses the registry. All Analysis Services server properties that control query log behavior are accessible through SQL Management Studio or by directly modifying the Analysis Services configuration file.
• The format of the query log table format has changed. If you depend on the query log table, you must adjust your application so that it can use the new format.

Table of content

• Configuring Analysis Services to Capture Statistics About Running Queries
• The Dataset Column in the Query Log Table
• Query Log Cleanup
• Troubleshooting the Query Log

Read more...