Databases Reference
In-Depth Information
TABLE 23.2
QueryLog
Server Properties
Name
Description
By default, this property is empty—Analysis
Services doesn't log any queries to a query
log. You can change this property to a valid
connection string pointing to a valid copy of
a SQL Server database. If
CreateQuery
LogTable
value is set to
1
, Analysis Server
creates a new table in the SQL Server data-
base unless one with the same name
already exists.
Log\QueryLog\QueryLogConnectionString
The name of the table in the SQL Server
database that holds the Analysis Services
query log. By default, this property is set to
OlapQueryLog.
Log\QueryLog\QueryLogTableName
If this property is set to
1
, Analysis Services
attempts to create a new table in the SQL
Server database that the
QueryLog
ConnectionString
property points to. If
the table already exists, Analysis Services
continues logging queries into it. By default,
this property is set to
0
.
Log\QueryLog\CreateQueryLogTable
NOTE
The Analysis Services account must have sufficient privileges to create a query log
table. We recommend that you create a dedicated SQL Server database to hold the
Analysis Services query log. If your SQL Server database is not available for Analysis
Services to log queries against, you won't see any notice of this in the user interface.
Monitor the Windows event log for events that indicate query log errors.
When Analysis Services starts, it tries to connect to the SQL Server instance that holds the
query log. If that server instance isn't available at that time, Analysis Services waits for 60
seconds (the default amount of time) before it proceeds. If you use Service Control Manager
(SCM) to start Analysis Services, SCM might time out before Analysis Services starts.
Nevertheless, it will eventually start. Use the server properties in Table 23.2 to set up a
query log table, use the cube browser to browse the
Warehouse and Sales
cube, and then
query the table to see it contents. The result you see should be similar to Figure 23.9.
Search WWH ::
Custom Search