:::: MENU ::::

Logging and Error Reporting for SQL Server Analysis Server

  • May 13 / 2009
  • 0
Analysis Services SSAS, dbDigger, Monitoring and Analysis

Logging and Error Reporting for SQL Server Analysis Server

Analysis Services records a query log to enable you to analyze query patterns and improve your aggregation design. You can configure the properties of this query log. You can also enable a processing log and enable Analysis Services error reporting.

Query Log

To enable the Usage Based Optimization Wizard to design aggregations based on past usage patterns and to enable the Usage Analysis Wizard to generate reports analyzing query usage, Analysis Services records the levels touched by every Nth query in a query log. By default, every tenth query is logged. The default location for the query log is C:Program FilesMicrosoft Analysis ServicesBinmsmdqlog.mdb. This file, like any log file, should be secured from unauthorized access.

Consult us to explore the Databases. Contact us