SHOWPLAN_ALL_FOR_QUERY_COMPILE, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER

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

SHOWPLAN_ALL_FOR_QUERY_COMPILE properties

SHOWPLAN_ALL_FOR_QUERY_COMPILE has 31 properties (1 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_ALL_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]
TIME_CREATED__Event21 [uint64]
TransactionIDTRC_PERFORMANCE20 [Sint64]
XactSequenceTRC_PERFORMANCE20 [Sint64]

Detailed description of SHOWPLAN_ALL_FOR_QUERY_COMPILE properties

Local properties (1) of SHOWPLAN_ALL_FOR_QUERY_COMPILE class

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

Derived properties (30) of SHOWPLAN_ALL_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_ALL_FOR_QUERY_COMPILE Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
abstractTrue

SHOWPLAN_ALL_FOR_QUERY_COMPILE System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:SHOWPLAN_ALL_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_COUNT31___SYSTEM3
__RELPATH'SHOWPLAN_ALL_FOR_QUERY_COMPILE'___SYSTEM8
__DYNASTY'__SystemClass'___SYSTEM8
__SUPERCLASS'TRC_PERFORMANCE'___SYSTEM8
__CLASS'SHOWPLAN_ALL_FOR_QUERY_COMPILE'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to SHOWPLAN_ALL_FOR_QUERY_COMPILE

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