Log Properties

Microsoft SQL Server Analysis Services supports the log server properties listed in the following tables. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties.

General

  • File
    A string property that identifies the name of the server log file. This property only applies when a disk file is used for logging, as opposed to a database table (the default behavior).

    The default value for this property is msmdsrv.log.

  • FileBufferSize
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • MessageLogs
    An advanced property that you should not change, except under the guidance of Microsoft support.

Error Log

  • ErrorLog\ErrorLogFileName
    A property used as a default during processing operation performed by the server.

  • ErrorLog\ErrorLogFileSize
    A property used as a default during processing operation performed by the server.

  • ErrorLog\IgnoreDataTruncation
    A property used as a default during processing operation performed by the server.

  • ErrorLog\KeyErrorAction
    A property used as a default during processing operation performed by the server.

  • ErrorLog\KeyErrorLimit
    A property used as a default during processing operation performed by the server.

  • ErrorLog\KeyErrorLimitAction
    A property used as a default during processing operation performed by the server.

  • ErrorLog\KeyErrorLogFile
    A property used as a default during processing operation performed by the server.

  • ErrorLog\ LogErrorTypes\KeyNotFound
    A property used as a default during processing operation performed by the server.

  • ErrorLog\ LogErrorTypes\KeyDuplicate
    A property used as a default during processing operation performed by the server.

  • ErrorLog\ LogErrorTypes\NullKeyConvertedToUnknown
    A property used as a default during processing operation performed by the server.

  • ErrorLog\ LogErrorTypes\NullKeyNotAllowed
    A property used as a default during processing operation performed by the server.

Exception

  • Exception\CreateAndSendCrashReports
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Exception\CrashReportsFolder
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Exception\SQLDumperFlagsOn
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Exception\SQLDumperFlagsOff
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Exception\MiniDumpFlagsOn
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Exception\MinidumpErrorList
    An advanced property that you should not change, except under the guidance of Microsoft support.

Flight Recorder

  • FlightRecorder\Enabled
    A Boolean property that indicates whether the flight recorder feature is enabled.

  • FlightRecorder\FileSizeMB
    A signed 32-bit integer property that defines the size of the flight recorder disk file, in megabytes.

  • FlightRecorder\LogDurationSec
    A signed 32-bit integer property that defines the frequency that the flight recorder is rolled over, in seconds.

  • FlightRecorder\SnapshotDefinitionFile
    A string property that defines the name of the snapshot definition file, containing discover commands that are issued to the server when a snapshot is taken.

    The default value for this property is blank, which in turn defaults to file name FlightRecorderSnapshotDef.xml.

  • FlightRecorder\SnapshotFrequencySec
    A signed 32-bit integer property that defines the snapshot frequency, in seconds.

  • FlightRecorder\TraceDefinitionFile
    A string property that specifies the name of the flight recorder trace definition file.

    The default value for this property is blank, which in turn defaults to FlightRecorderTraceDef.xml.

Query Log

  • QueryLog\QueryLogFileName
    A string property that specifies the name of the query log file. This property only applies when a disk file is used for logging, as opposed to a database table (the default behavior).

  • QueryLog\QueryLogSampling
    A signed 32-bit integer property that specifies the query log sampling rate.

    The default value for this property is 10, meaning that 1 out of every 10 server queries is logged.

  • QueryLog\QueryLogFileSize
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • QueryLog\QueryLogConnectionString
    A string property that specifies the connection to the query log database.

  • QueryLog\QueryLogTableName
    A string property that specifies the name of the query log table.

    The default value for this property is OlapQueryLog.

  • QueryLog\CreateQueryLogTable
    A Boolean property that specifies whether to create the query log table.

    The default value for this property is false, which indicates the server will not automatically create the log table and will not log query events.

Note

For more information about configuring the query log, see Configuring the Analysis Services Query Log.

Trace

  • Trace\TraceBackgroundDistributionPeriod
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceBackgroundFlushPeriod
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceFileBufferSize
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceFileWriteTrailerPeriod
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceMaxRowsetSize
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceProtocolTraffic
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceQueryResponseTextChunkSize
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceReportFQDN
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceRequestParameters
    An advanced property that you should not change, except under the guidance of Microsoft support.

  • Trace\TraceRowsetBackgroundFlushPeriod
    An advanced property that you should not change, except under the guidance of Microsoft support.