Share via

Notification Events Data Columns

  • Article

Notification events are events that are not directly caused by users of Microsoft SQL Server Analysis Services. For example, notifications occur because of users updating underlying tables for proactive caching.

The Notifications Events event category has the following event class:

Event ID

Event Name

Event Description

39

Notification

Notification event.

40

User Defined

User defined Event.

The following table lists the data columns for the event class.

Notification

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

0

Proactive Caching Begin

1

Proactive Caching End

2

Flight Recorder Started

3

Flight Recorder Stopped

4

Configuration Properties Updated

5

SQL Trace

6

Object Created

7

Object Deleted

8

Object Altered

9

Proactive Caching Polling Begin

10

Proactive Caching Polling End

11

Flight Recorder Snapshot Begin

12

Flight Recorder Snapshot End

13

Proactive Caching: notifiable object updated

14

Lazy Processing: start processing

15

Lazy Processing: processing complete

16

SessionOpened Event Begin

17

SessionOpened Event End

18

SessionClosing Event Begin

19

SessionClosing Event End

20

CubeOpened Event Begin

21

CubeOpened Event End

22

CubeClosing Event Begin

23

CubeClosing Event End

24

Transaction abort requested

CurrentTime

2

5

Contains the current time of the notification 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 amount of time (in milliseconds) taken by the event.

IntegerData

10

1

Contains the integer data associated with the notification event. When the EventSubclass column is 8, values are:

1 = Created

2 = Deleted

3 = Changed object's properties

4 = Changed properties of the object's children

6 = Children added

7 = Children deleted

8 = Object fully processed

9 = Object partially processed

10 = Object unprocessed

11 = Object fully optimized

12 = Object partially optimized

13 = Object not optimized

ObjectID

11

8

Contains the Object ID for which this notification is issued; this is a string value.

ObjectType

12

1

Contains the object type associated with the notification event.

ObjectName

13

8

Contains the object name associated with the notification event.

ObjectPath

14

8

Contains the object path associated with the notification event. The path is returned as a comma-separated list of parents, starting with the object's parent.

ObjectReference

15

8

Contains the object reference for the progress report end event. The object reference is encoded as XML by all parents by using tags to describe the object.

ConnectionID

25

1

Contains the unique connection ID associated with the notification event.

DatabaseName

28

8

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

NTUserName

32

8

Contains the Windows user name associated with the notification event.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Contains the session ID associated with the notification event.

NTCanonicalUserName

40

8

Contains the Windows user name associated with the notification 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 notification event. The SPID directly corresponds to the session GUID used by XMLA.

TextData

42

9

Contains the text data associated with the notification event.

ServerName

43

8

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

RequestProperties

45

9

Contains the properties of the XMLA request.

User Defined

Column Name

Column Id

Column Type

Column Description

EventClass

0

1

Event Class is used to categorize events.

EventSubclass

1

1

A specific user event subclass that provides additional information about each event class.

CurrentTime

2

5

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

IntegerData

10

1

A specific user defined event information.

ConnectionID

25

1

Contains the unique connection ID associated with the notification event.

DatabaseName

28

8

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

NTUserName

32

8

Contains the Windows user name associated with the notification event.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Contains the session ID associated with the notification event.

NTCanonicalUserName

40

8

Contains the Windows user name associated with the notification 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 notification event. The SPID directly corresponds to the session GUID used by XMLA.

TextData

42

9

Contains the text data associated with the notification event.

ServerName

43

8

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

See Also

Other Resources

Notification Events Event Category