Location and types of logs
Analysis Services provides the logs described below.
File name or Location
|
Type
|
Used for
|
On by default
|
|---|---|---|---|
Msmdsrv.log
|
Error log
|
Routine monitoring and basic troubleshooting
|
Yes
|
OlapQueryLog table in a relational database
|
Query log
|
Collect inputs for the Usage Optimization Wizard
|
No
|
SQLDmp<guid>.mdmp files
|
Crashes and exceptions
|
Deep troubleshooting
|
No
|
We highly recommend the following link for additional information resources not covered in this topic: Initial data collection tips from Microsoft Support.
See Configuring the Analysis Services Query Log to learn more about query log configuration. Although the paper is quite old, query log configuration has not changed in recent releases and the information it contains still applies.
Mini dump (.mdmp) files
Dump files capture data used for analyzing extraordinary events. Analysis Services automatically generates mini dumps (.mdmp) in response to a server crash, exception, and some configuration errors. The feature is enabled, but does not send crash reports automatically.
Crash reports are configured through the Exception section in the Msmdsrv.ini file. These settings control memory dump file generation. The following snippet shows the default values:
<Exception> <CreateAndSendCrashReports>1</CreateAndSendCrashReports> <CrashReportsFolder/> <SQLDumperFlagsOn>0x0</SQLDumperFlagsOn> <SQLDumperFlagsOff>0x0</SQLDumperFlagsOff> <MiniDumpFlagsOn>0x0</MiniDumpFlagsOn> <MiniDumpFlagsOff>0x0</MiniDumpFlagsOff> <MinidumpErrorList>0xC1000000, 0xC1000001, 0xC102003F, 0xC1360054, 0xC1360055</MinidumpErrorList> <ExceptionHandlingMode>0</ExceptionHandlingMode> <CriticalErrorHandling>1</CriticalErrorHandling> <MaxExceptions>500</MaxExceptions> <MaxDuplicateDumps>1</MaxDuplicateDumps> </Exception>
Configure Crash Reports
Unless otherwise directed by Microsoft Support, most administrators use the default settings. This older KB article is still used to provide instruction on how to configure dump files: How to configure Analysis Services to generate memory dump files.
The configuration setting most likely to be modified is the CreateAndSendCrashReports setting used to determine whether a memory dump file will be generated.
Value
|
Description
|
|---|---|
0
|
Turns off the memory dump file. All other settings under the Exception section are ignored.
|
1
|
(Default) Enables, but does not send, the memory dump file.
|
2
|
Enables and automatically sends an error report to Microsoft.
|
CrashReportsFolder is the location of the dump files. By default, an .mdmp file and associated log records can be found in the \Olap\Log folder.
SQLDumperFlagsOn is used to generate a full dump. By default, full dumps are not enabled. You can set this property to 0x34.
The following links provide more background:
Комментариев нет:
Отправить комментарий