Database Reference
In-Depth Information
should change the
<Log><QueryLog><QueryLogSampling>
property value to
1
so that the SSAS logs subcube requests for every query.
SSAS can use its own memory manager or the Windows memory manager. If
your SSAS instance consistently becomes unresponsive, you could try using the
Windows memory manager. Set
<Memory><MemoryHeapType>
to
2
and
<Memory><HeapTypeForObjects>
to
0
. The Analysis Services memory manager
values are
1
for both the properties. You must restart the SSAS service for the
changes to these properties to take effect.
The
<Memory><PreAllocate>
property specifies the percentage of total memory
to be reserved at SSAS startup. SSAS normally allocates memory dynamically as
it is required by queries and processing jobs. In some cases, you can achieve per-
formance improvement by allocating a portion of the memory when the SSAS ser-
vice starts.
Note
Setting this value will increase the time required to start the service. The memory
will not be released back to the operating system until you stop the SSAS ser-
vice. You must restart the SSAS service for changes to this property to take ef-
fect.
The
<Log><FlightRecorder><FileSizeMB>
and
<Log><FlightRecorder-
><LogDurationSec>
properties control the size and age of the
FlightRecorder
trace file before it is recycled. You can supply your own trace definition file to include
the trace events and columns you wish to monitor using the
<Log><FlightRe-
corder><TraceDefinitionFile>
property. If
FlightRecorder
collects useful
trace events, it can be an invaluable troubleshooting tool. By default, the file is only
allowed to grow to 10 MB or 60 minutes. Long processing jobs can take up much
more space, and their duration could be much longer than 60 minutes. Hence, you
should adjust the settings as necessary for your monitoring needs. You should also
adjust the trace events and columns to be captured by
FlightRecorder
. You
should consider adjusting the duration to cover three days (in case the issue you are
researching happens over a weekend).
Search WWH ::
Custom Search