SHOWPLAN_XML_FOR_QUERY_COMPILE, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER

Class | Methods | Properties (32) | Qualifiers (1) | Instances | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

SHOWPLAN_XML_FOR_QUERY_COMPILE properties

SHOWPLAN_XML_FOR_QUERY_COMPILE has 32 properties (2 Local, 30 Derived)

NameOriginCIMType
ApplicationNameTRC_PERFORMANCE8 [String]
BinaryDataTRC_PERFORMANCE17 [Uint8]
ClientProcessIDTRC_PERFORMANCE3 [Sint32]
ComputerNameALL_EVENTS8 [String]
DatabaseIDTRC_PERFORMANCE3 [Sint32]
DatabaseNameTRC_PERFORMANCE8 [String]
EventSequenceTRC_ALL_EVENTS20 [Sint64]
GroupIDTRC_PERFORMANCE3 [Sint32]
HostNameTRC_PERFORMANCE8 [String]
IntegerDataTRC_PERFORMANCE3 [Sint32]
IsSystemTRC_PERFORMANCE3 [Sint32]
LineNumberTRC_PERFORMANCE3 [Sint32]
LoginNameTRC_PERFORMANCE8 [String]
LoginSidTRC_PERFORMANCE17 [Uint8]
NestLevelTRC_PERFORMANCE3 [Sint32]
NTDomainNameTRC_PERFORMANCE8 [String]
NTUserNameSHOWPLAN_XML_FOR_QUERY_COMPILE8 [String]
ObjectIDTRC_PERFORMANCE3 [Sint32]
ObjectNameTRC_PERFORMANCE8 [String]
ObjectTypeTRC_PERFORMANCE3 [Sint32]
PostTimeALL_EVENTS101 [DateTime]
RequestIDTRC_PERFORMANCE3 [Sint32]
SECURITY_DESCRIPTOR__Event17 [uint8]
ServerNameTRC_PERFORMANCE8 [String]
SessionLoginNameTRC_ALL_EVENTS8 [String]
SPIDALL_EVENTS3 [Sint32]
SQLInstanceALL_EVENTS8 [String]
StartTimeTRC_ALL_EVENTS101 [DateTime]
TextDataSHOWPLAN_XML_FOR_QUERY_COMPILE8 [String]
TIME_CREATED__Event21 [uint64]
TransactionIDTRC_PERFORMANCE20 [Sint64]
XactSequenceTRC_PERFORMANCE20 [Sint64]

Detailed description of SHOWPLAN_XML_FOR_QUERY_COMPILE properties

Local properties (2) of SHOWPLAN_XML_FOR_QUERY_COMPILE class

▲ NTUserName property
CIMTYPE'String'
NTUserName property is in 91 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ TextData property
CIMTYPE'String'
TextData property is in 85 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace

Derived properties (30) of SHOWPLAN_XML_FOR_QUERY_COMPILE class

▲ ApplicationName property
CIMTYPE'String'
ApplicationName property is in 98 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 3 namespaces
▲ BinaryData property
CIMTYPE'Uint8'
BinaryData property is in 29 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ ClientProcessID property
CIMTYPE'Sint32'
ClientProcessID property is in 85 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ ComputerName property
CIMTYPE'String'
ComputerName property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 11 namespaces
▲ DatabaseID property
CIMTYPE'Sint32'
DatabaseID property is in 107 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ DatabaseName property
CIMTYPE'String'
DatabaseName property is in 287 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 4 namespaces
▲ EventSequence property
CIMTYPE'Sint64'
EventSequence property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ IntegerData property
CIMTYPE'Sint32'
IntegerData property is in 22 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ LineNumber property
CIMTYPE'Sint32'
LineNumber property is in 20 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 3 namespaces
▲ LoginName property
CIMTYPE'String'
LoginName property is in 363 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ LoginSid property
CIMTYPE'Uint8'
LoginSid property is in 103 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ NestLevel property
CIMTYPE'Sint32'
NestLevel property is in 39 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ NTDomainName property
CIMTYPE'String'
NTDomainName property is in 98 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ ObjectName property
CIMTYPE'String'
ObjectName property is in 280 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 5 namespaces
▲ ObjectType property
CIMTYPE'Sint32'
ObjectType property is in 299 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 6 namespaces
▲ PostTime property
CIMTYPE'DateTime'
PostTime property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ RequestID property
CIMTYPE'Sint32'
RequestID property is in 96 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 4 namespaces
▲ SECURITY_DESCRIPTOR property
CIMTYPE'uint8'
SECURITY_DESCRIPTOR property is in 407 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 142 namespaces
▲ ServerName property
CIMTYPE'String'
ServerName property is in 91 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 23 namespaces
▲ SessionLoginName property
CIMTYPE'String'
SessionLoginName property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ SPID property
CIMTYPE'Sint32'
SPID property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ SQLInstance property
CIMTYPE'String'
SQLInstance property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
▲ StartTime property
CIMTYPE'DateTime'
StartTime property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 24 namespaces
▲ TIME_CREATED property
CIMTYPE'uint64'
TIME_CREATED property is in 409 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 142 namespaces
▲ TransactionID property
CIMTYPE'Sint64'
TransactionID property is in 93 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 2 namespaces
▲ XactSequence property
CIMTYPE'Sint64'
XactSequence property is in 64 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace

SHOWPLAN_XML_FOR_QUERY_COMPILE Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
abstractTrue✓✓✗✗✗

SHOWPLAN_XML_FOR_QUERY_COMPILE System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:SHOWPLAN_XML_FOR_QUERY_COMPILE'___SYSTEM8✗✗
__NAMESPACE'ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['TRC_PERFORMANCE', 'TRC_ALL_EVENTS', 'ALL_EVENTS', '__ExtrinsicEvent', '__Event', '__IndicationRelated', '__SystemClass']___SYSTEM8✗✓
__PROPERTY_COUNT32___SYSTEM3✗✗
__RELPATH'SHOWPLAN_XML_FOR_QUERY_COMPILE'___SYSTEM8✗✗
__DYNASTY'__SystemClass'___SYSTEM8✗✗
__SUPERCLASS'TRC_PERFORMANCE'___SYSTEM8✗✗
__CLASS'SHOWPLAN_XML_FOR_QUERY_COMPILE'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to SHOWPLAN_XML_FOR_QUERY_COMPILE

Number of classes:3
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
SHOWPLAN_ALL_FOR_QUERY_COMPILE0310--✓-
SP_RECOMPILE0340--✓-
SQL_STMTRECOMPILE0340--✓-
comments powered by Disqus
WUtils.com