Jaa

Progress Reports Data Columns

  • Artikkeli

The Progress Reports event category has the following event classes:

  • Progress Report Begin class
  • Progress Report End class
  • Progress Report Current class
  • Progress Report Error class

The following tables list the data columns for each of these event classes.

Progress Report Begin–Data Columns

Data Column Description

ConnectionID

Contains the unique connection ID associated with the reported event.

TextData

Contains the text data associated with the reported event.

ServerName

Contains the name of the instance of Microsoft SQL Server 2005 Analysis Services (SSAS) on which the reported event occurred.

CurrentTime

Contains the current time of the reported event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the reported event occurred.

EventSubclass

Contains the class of event within the progress report event. Values are:

  • Process
  • Merge
  • Delete
  • DeleteOldAggregations
  • Rebuild
  • Commit
  • Rollback
  • CreateIndexes
  • CreateTable
  • InsertInto
  • Transaction
  • Initialize
  • Discretize
  • Query
  • CreateView
  • WriteData
  • ReadData
  • GroupData
  • GroupDataRecord
  • BuildIndex
  • Aggregate
  • BuildDecode
  • WriteDecode
  • BuildDMDecode
  • ExecuteSQL
  • NowExecutingSQL
  • ExecuteModifiedSQL
  • Connecting
  • BuildAggsAndIndexes
  • MergeAggsOnDisk
  • BuildIndexForRigidAggs
  • BuildIndexForFlexibleAggs
  • WriteAggsAndIndexes
  • WriteSegment
  • DataMiningProgress
  • ReadBufferFullReport
  • ProactiveCacheConversion
  • Backup
  • Restore
  • Synchronize

NTCanonicalUserName

Contains the Windows user name associated with the reported event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

NTUserName

Contains the Windows user account associated with the reported event.

ObjectID

Contains the object ID (a string) associated with the reported event.

ObjectName

Contains the name of the object associated with the reported event.

ObjectPath

Contains the object path for the object associated with the reported event, as a comma-separated list of parents starting with the object's parents.

ObjectReference

Contains the object reference for the reported event, encoded as XML for all parents and using tags to describe the object.

ObjectType

Contains the type of object associated with the reported event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the reported event. The SPID directly corresponds to the session GUID used by XML for Analysis (XMLA).

StartTime

Contains the time (if available) at which the reported event started. For filtering, expected formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

SessionType

Contains the session type (the entity causing the event) associated with the reported event. For processing events, values are:

1= User

2= Proactive Caching

3= Lazy processing

JobID

Contains the job ID associated with the reported event.

NTDomainName

Contains the Windows domain account associated with the reported event.

SessionID

Contains the session ID associated with the reported event.

Progress Report End–Data Columns

Data Column Description

ConnectionID

Contains the unique connection ID associated with the reported event.

TextData

Contains the text data associated with the reported event.

ServerName

Contains the name of the instance of Analysis Services on which the reported event occurred.

CurrentTime

Contains the current time of the reported event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the reported event occurred.

Duration

Contains the length of time between when the reported event began and ended.

EndTime

Contains the time at which the reported event ended. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

EventSubclass

Contains the class of event within the progress report event. Values are:

  • Process
  • Merge
  • Delete
  • DeleteOldAggregations
  • Rebuild
  • Commit
  • Rollback
  • CreateIndexes
  • CreateTable
  • InsertInto
  • Transaction
  • Initialize
  • Discretize
  • Query
  • CreateView
  • WriteData
  • ReadData
  • GroupData
  • GroupDataRecord
  • BuildIndex
  • Aggregate
  • BuildDecode
  • WriteDecode
  • BuildDMDecode
  • ExecuteSQL
  • ExecuteModifiedSQL
  • Connecting
  • RowsAffected
  • BuildAggsAndIndexes
  • MergeAggsOnDisk
  • BuildIndexForRigidAggs
  • BuildIndexForFlexibleAggs
  • WriteAggsAndIndexes
  • WriteSegment
  • DataMiningProgress
  • ReadBufferFullReport
  • ProactiveCacheConversion
  • Backup
  • Restore
  • Synchronize

IntegerData

Contains the integer data associated with the reported event, such as the current count of the number of rows processed for a processing event.

NTCanonicalUserName

Contains the Windows user name associated with the reported event. The user name is in canonical form. For example, engineering.microsoft.com/software/user.

NTUserName

Contains the Windows user name associated with the reported event.

ObjectID

Contains the object ID (a string) associated with the reported event.

ObjectName

Contains the name of the object associated with the reported event.

ObjectPath

Contains the object path for the object associated with the reported event, as a comma separated list of parents starting with the object's parents.

ObjectReference

Contains the object reference for the reported event, encoded as XML for all parents and using tags to describe the object.

ObjectType

Contains the type of object associated with the reported event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the reported event. The SPID directly corresponds to the session GUID used by XML for Analysis (XMLA).

StartTime

Contains the time (if available) at which the reported event started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

CPUTime

Contains the CPU time (in milliseconds) used by the process between the time the reported event started and stopped.

Error

Contains the error number of any error associated the reported event.

Severity

Contains the severity level of an exception associated the reported event. Values are:

0 = Success

1 = Informational

2 = Warning

3 = Error

Success

Contains the success or failure of the server reported event. Values are:

0 = Failure

1 = Success

SessionType

Contains the session type (the entity causing the event) associated with the reported event. For processing events, values are:

1= User

2= Proactive Caching

3= Lazy processing

JobID

Contains the job ID associated with the reported event.

ProgressTotal

Contains the progress total for the reported event.

NTDomainName

Contains the Windows domain account associated with the reported event.

SessionID

Contains the session ID associated with the reported event.

Progress Report Current–Data Columns

Data Column Description

ConnectionID

Contains the unique connection ID associated with the reported event.

TextData

Contains the text data associated with the reported event.

ServerName

Contains the name of the instance of Analysis Services on which the reported event occurred.

CurrentTime

Contains the current time of the reported event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the reported event occurred.

EventSubclass

Contains the class of event within the progress report event. Values are:

  • Process
  • Merge
  • Delete
  • DeleteOldAggregations
  • Rebuild
  • Commit
  • Rollback
  • CreateIndexes
  • CreateTable
  • InsertInto
  • Transaction
  • Initialize
  • Discretize
  • Query
  • CreateView
  • WriteData
  • ReadData
  • GroupData
  • GroupDataRecord
  • BuildIndex
  • Aggregate
  • BuildDecode
  • WriteDecode
  • BuildDMDecode
  • ExecuteSQL
  • NowExecutingSQL
  • ExecuteModifiedSQL
  • Connecting
  • RowsAffected
  • BuildAggsAndIndexes
  • MergeAggsOnDisk
  • BuildIndexForRigidAggs
  • BuildIndexForFlexibleAggs
  • WriteAggsAndIndexes
  • WriteSegment
  • DataMiningProgress
  • ReadBufferFullReport
  • ProactiveCacheConversion
  • Backup
  • Restore
  • Synchronize
  • Build Processing Schedule

IntegerData

Contains the integer data associated with the reported event, such as the current count of the number of rows processed for a processing event.

ObjectID

Contains the object ID (a string) associated with the reported event.

ObjectName

Contains the name of the object associated with the reported event.

ObjectPath

Contains the object path for the object associated with the reported event, as a comma separated list of parents starting with the object's parents.

ObjectReference

Contains the object reference for the reported event, encoded as XML for all parents and using tags to describe the object.

ObjectType

Contains the type of object associated with the reported event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the reported event. The SPID directly corresponds to the session GUID used by XML for Analysis (XMLA).

StartTime

Contains the time (if available) at which the reported event started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

SessionType

Contains the session type (the entity causing the event) associated with the reported event. For processing events, values are:

1= User

2= Proactive Caching

3= Lazy processing

JobID

Contains the job ID associated with the reported event.

ProgressTotal

Contains the progress total for the reported event.

SessionID

Contains the session ID associated with the reported event.

Progress Report Error–Data Columns

Data Column Description

Event Sub Class

Contains the class of event within the progress report error event. Values are:

  • Merge - 2
  • Delete - 3
  • DeleteOldAggregations
  • Rebuild
  • Commit
  • Rollback
  • CreateIndexes
  • CreateTable
  • InsertInto
  • Transaction
  • Initialize
  • Discretize
  • Query
  • CreateView
  • WriteData
  • ReadData
  • GroupData
  • GroupDataRecord
  • BuildIndex
  • Aggregate
  • BuildDecode
  • WriteDecode
  • BuildDMDecode
  • ExecuteSQL
  • NowExecutingSQL
  • ExecuteModifiedSQL
  • Connecting
  • RowsAffected
  • BuildAggsAndIndexes
  • MergeAggsOnDisk
  • BuildIndexForRigidAggs
  • BuildIndexForFlexibleAggs
  • WriteAggsAndIndexes
  • WriteSegment
  • DataMiningProgress
  • ReadBufferFullReport
  • ProactiveCacheConversion
  • Backup
  • Restore
  • Synchronize
  • Build Processing Schedule

ConnectionID

Contains the unique connection ID associated with the reported event.

TextData

Contains the text data associated with the reported event.

ServerName

Contains the name of the instance of Analysis Services on which the reported event occurred.

CurrentTime

Contains the current time of the reported event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

DatabaseName

Contains the name of the database in which the reported event occurred.

Duration

Contains the length of time between when the reported event began and ended.

EndTime

Contains the time at which the reported event ended. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

EventSubclass

Contains the class of event within the progress report event. Values are:

1 = Finished Successfully

2 = Rollback

IntegerData

Contains the integer data associated with the reported event, such as the current count of the number of rows processed for a processing event.

ObjectID

Contains the object ID (a string) associated with the reported event.

ObjectName

Contains the name of the object associated with the reported event.

ObjectPath

Contains the object path for the object associated with the reported event, as a comma separated list of parents starting with the object's parents.

ObjectReference

Contains the object reference for the reported event, encoded as XML for all parents and using tags to describe the object.

ObjectType

Contains the type of object associated with the reported event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the reported event. The SPID directly corresponds to the session GUID used by XML for Analysis (XMLA).

StartTime

Contains the time (if available) at which the reported event started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

Error

Contains the error number of any error associated the reported event.

Severity

Contains the severity level of an exception associated the reported event. Values are:

0 = Success

1 = Informational

2 = Warning

3 = Error

SessionType

Contains the session type (the entity causing the event) associated with the reported event. For processing events, values are:

1= Regular

2= Proactive Caching

3= Lazy processing

JobID

Contains the job ID associated with the reported event.

ProgressTotal

Contains the progress total for the reported event.

SessionID

Contains the session ID associated with the reported event.

See Also

Other Resources

Progress Reports Event Category

Help and Information

Getting SQL Server 2005 Assistance