Database Reference
In-Depth Information
Event class and
event
Description
Errors and warnings:
Error
Useful for detecting and resolving any errors encountered
during processing. For example, missing attribute keys will
fail partition processing unless you explicitly specify the op-
tion to ignore missing key errors.
Locks:
Deadlock
,
Lock Acquired
,
Lock Released
,
Lock Timeout
,
Lock Waiting
Analysis Services' processing job can be blocked if there is
a conflicting processing command. Additionally, long running
queries may prevent SSAS from updating metadata. You
could also experience delays if the processing job runs
while the database is being synchronized.
Progress reports:
Progress Report
Begin
,
Progress
Report End
,
Pro-
gress Report
Current
, and
Pro-
gress Report
Error
Progress reports are particularly useful for monitoring pro-
cessing in-flight. For example,
Progress Report Cur-
rent
shows the number of rows read for a partition or di-
mension being processed, whereas
Progress Report
Error
displays the error encountered during a specific ob-
ject's processing. These events also show the SQL state-
ments executed against the relational database.
Notification events:
Notification
This event is helpful in detecting when SSAS has completed
the creation of new files for the object, and enters the com-
mit phase. During the commit phase, SSAS acquires neces-
sary locks to delete the existing object and replace it with
the new set of files. Depending on other activities taking
place on the server, the commit phase could be lengthy.
Search WWH ::
Custom Search