Delen via

Progress Reports Data Columns

  • Artikel

The Progress Reports event category has the following event classes:

Event ID

Event Name

Event Description

5

Progress Report Begin

Progress report begin.

6

Progress Report End

Progress report end.

7

Progress Report Current

Progress report current.

8

Progress Report Error

Progress report error.

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

Progress Report Begin–Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

1

Process

29

MergeAggsOnDisk

2

Merge

30

BuildIndexForRigidAggs

3

Delete

31

BuildIndexForFlexibleAggs

4

DeleteOldAggregations

32

WriteAggsAndIndexes

5

Rebuild

33

WriteSegment

6

Commit

34

DataMiningProgress

7

Rollback

35

ReadBufferFullReport

8

CreateIndexes

36

ProactiveCacheConversion

9

CreateTable

37

Backup

10

InsertInto

38

Restore

11

Transaction

39

Synchronize

12

Initialize

40

Build Processing Schedule

13

Discretize

41

Detach

14

Query

42

Attach

15

CreateView

43

Analyze\Encode Data

16

WriteData

44

Compress Segment

17

ReadData

45

Write Table Column

18

GroupData

46

Relationship Build Prepare

19

GroupDataRecord

47

Build Relationship Segment

20

BuildIndex

48

Load

21

Aggregate

49

Metadata Load

22

BuildDecode

50

Data Load

23

WriteDecode

51

Post Load

24

BuildDMDecode

52

Metadata traversal during Backup

25

ExecuteSQL

53

VertiPaq

26

ExecuteModifiedSQL

54

Hierarchy processing

27

Connecting

55

Switching dictionary

28

BuildAggsAndIndexes

CurrentTime

2

5

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

StartTime

3

5

Contains the time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

JobID

7

1

Contains the job ID associated with the reported event.

SessionType

8

8

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

ObjectID

11

8

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

ObjectType

12

1

Contains the object type.

ObjectName

13

8

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

ObjectPath

14

8

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

15

8

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

ConnectionID

25

1

Contains the unique connection ID associated with the reported event.

DatabaseName

28

8

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

NTUserName

32

8

Contains the Windows user account associated with the reported event.

NTDomainName

33

8

Contains the Windows domain account associated with the reported event.

SessionID

39

8

Contains the session ID associated with the reported event.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

SPID

41

1

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).

TextData

42

9

Contains the text data associated with the reported event.

ServerName

43

8

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

Progress Report End–Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

1

Process

29

MergeAggsOnDisk

2

Merge

30

BuildIndexForRigidAggs

3

Delete

31

BuildIndexForFlexibleAggs

4

DeleteOldAggregations

32

WriteAggsAndIndexes

5

Rebuild

33

WriteSegment

6

Commit

34

DataMiningProgress

7

Rollback

35

ReadBufferFullReport

8

CreateIndexes

36

ProactiveCacheConversion

9

CreateTable

37

Backup

10

InsertInto

38

Restore

11

Transaction

39

Synchronize

12

Initialize

40

Build Processing Schedule

13

Discretize

41

Detach

14

Query

42

Attach

15

CreateView

43

Analyze\Encode Data

16

WriteData

44

Compress Segment

17

ReadData

45

Write Table Column

18

GroupData

46

Relationship Build Prepare

19

GroupDataRecord

47

Build Relationship Segment

20

BuildIndex

48

Load

21

Aggregate

49

Metadata Load

22

BuildDecode

50

Data Load

23

WriteDecode

51

Post Load

24

BuildDMDecode

52

Metadata traversal during Backup

25

ExecuteSQL

53

VertiPaq

26

ExecuteModifiedSQL

54

Hierarchy processing

27

Connecting

55

Switching dictionary

28

BuildAggsAndIndexes

CurrentTime

2

5

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

StartTime

3

5

Contains the time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Contains the time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

Duration

5

2

Contains the elapsed amount of time (in milliseconds) taken by the event.

CPUTime

6

2

Contains the amount of CPU time (in milliseconds) used by the event.

JobID

7

1

Contains the job ID associated with the reported event.

SessionType

8

8

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

ProgressTotal

9

1

Contains the progress total for the reported event.

IntegerData

10

1

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

11

8

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

ObjectType

12

1

Contains the object type.

ObjectName

13

8

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

ObjectPath

14

8

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

15

8

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

Severity

22

1

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

0 = Success

1 = Informational

2 = Warning

3 = Error

Success

23

1

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

0 = Failure

1 = Success

Error

24

1

Contains the error number of a given event.

ConnectionID

25

1

Contains the unique connection ID associated with the reported event.

DatabaseName

28

8

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

NTUserName

32

8

Contains the Windows user account associated with the reported event.

NTDomainName

33

8

Contains the Windows domain account associated with the reported event.

SessionID

39

8

Contains the session ID associated with the reported event.

NTCanonicalUserName

40

8

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

SPID

41

1

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).

TextData

42

9

Contains the text data associated with the reported event.

ServerName

43

8

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

Progress Report Current–Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

1

Process

29

MergeAggsOnDisk

2

Merge

30

BuildIndexForRigidAggs

3

Delete

31

BuildIndexForFlexibleAggs

4

DeleteOldAggregations

32

WriteAggsAndIndexes

5

Rebuild

33

WriteSegment

6

Commit

34

DataMiningProgress

7

Rollback

35

ReadBufferFullReport

8

CreateIndexes

36

ProactiveCacheConversion

9

CreateTable

37

Backup

10

InsertInto

38

Restore

11

Transaction

39

Synchronize

12

Initialize

40

Build Processing Schedule

13

Discretize

41

Detach

14

Query

42

Attach

15

CreateView

43

Analyze\Encode Data

16

WriteData

44

Compress Segment

17

ReadData

45

Write Table Column

18

GroupData

46

Relationship Build Prepare

19

GroupDataRecord

47

Build Relationship Segment

20

BuildIndex

48

Load

21

Aggregate

49

Metadata Load

22

BuildDecode

50

Data Load

23

WriteDecode

51

Post Load

24

BuildDMDecode

52

Metadata traversal during Backup

25

ExecuteSQL

53

VertiPaq

26

ExecuteModifiedSQL

54

Hierarchy processing

27

Connecting

55

Switching dictionary

28

BuildAggsAndIndexes

CurrentTime

2

5

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

StartTime

3

5

Contains the time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

JobID

7

1

Contains the job ID associated with the reported event.

SessionType

8

8

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

ProgressTotal

9

1

Contains the progress total for the reported event.

IntegerData

10

1

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

11

8

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

ObjectType

12

1

Contains the object type.

ObjectName

13

8

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

ObjectPath

14

8

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

15

8

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

ConnectionID

25

1

Contains the unique connection ID associated with the reported event.

DatabaseName

28

8

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

SessionID

39

8

Contains the session ID associated with the reported event.

SPID

41

1

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).

TextData

42

9

Contains the text data associated with the reported event.

ServerName

43

8

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

Progress Report Error–Data Columns

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

Event Subclass provides additional information about each event class.

Sub Class Id

Sub Class Name

Sub Class Id

Sub Class Name

1

Process

29

MergeAggsOnDisk

2

Merge

30

BuildIndexForRigidAggs

3

Delete

31

BuildIndexForFlexibleAggs

4

DeleteOldAggregations

32

WriteAggsAndIndexes

5

Rebuild

33

WriteSegment

6

Commit

34

DataMiningProgress

7

Rollback

35

ReadBufferFullReport

8

CreateIndexes

36

ProactiveCacheConversion

9

CreateTable

37

Backup

10

InsertInto

38

Restore

11

Transaction

39

Synchronize

12

Initialize

40

Build Processing Schedule

13

Discretize

41

Detach

14

Query

42

Attach

15

CreateView

43

Analyze\Encode Data

16

WriteData

44

Compress Segment

17

ReadData

45

Write Table Column

18

GroupData

46

Relationship Build Prepare

19

GroupDataRecord

47

Build Relationship Segment

20

BuildIndex

48

Load

21

Aggregate

49

Metadata Load

22

BuildDecode

50

Data Load

23

WriteDecode

51

Post Load

24

BuildDMDecode

52

Metadata traversal during Backup

25

ExecuteSQL

53

VertiPaq

26

ExecuteModifiedSQL

54

Hierarchy processing

27

Connecting

55

Switching dictionary

28

BuildAggsAndIndexes

CurrentTime

2

5

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

StartTime

3

5

Contains the time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

EndTime

4

5

Contains the time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.

Duration

5

2

Contains the elapsed amount of time (in milliseconds) taken by the event.

JobID

7

1

Contains the job ID associated with the reported event.

SessionType

8

8

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

ProgressTotal

9

1

Contains the progress total for the reported event.

IntegerData

10

1

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

11

8

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

ObjectType

12

1

Contains the object type.

ObjectName

13

8

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

ObjectPath

14

8

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

15

8

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

Severity

22

1

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

0 = Success

1 = Informational

2 = Warning

3 = Error

Error

24

1

Contains the error number of a given event.

ConnectionID

25

1

Contains the unique connection ID associated with the reported event.

DatabaseName

28

8

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

SessionID

39

8

Contains the session ID associated with the reported event.

SPID

41

1

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).

TextData

42

9

Contains the text data associated with the reported event.

ServerName

43

8

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

See Also

Other Resources

Progress Reports Event Category