SHOWPLAN_XML, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER

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

SHOWPLAN_XML properties

SHOWPLAN_XML 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]
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_XML8 [String]
TIME_CREATED__Event21 [uint64]
TransactionIDTRC_PERFORMANCE20 [Sint64]
XactSequenceTRC_PERFORMANCE20 [Sint64]

Detailed description of SHOWPLAN_XML properties

Local properties (1) of SHOWPLAN_XML class

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 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 Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
abstractTrue

SHOWPLAN_XML System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:SHOWPLAN_XML'___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_XML'___SYSTEM8
__DYNASTY'__SystemClass'___SYSTEM8
__SUPERCLASS'TRC_PERFORMANCE'___SYSTEM8
__CLASS'SHOWPLAN_XML'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to SHOWPLAN_XML

Number of classes:7
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
ALTER_XML_SCHEMA_COLLECTION0130---
CREATE_XML_INDEX0170---
CREATE_XML_SCHEMA_COLLECTION0130---
DDL_XML_SCHEMA_COLLECTION_EVENTS3130---
DROP_XML_SCHEMA_COLLECTION0130---
SHOWPLAN_XML_FOR_QUERY_COMPILE0320---
SHOWPLAN_XML_STATISTICS_PROFILE0310---
comments powered by Disqus
WUtils.com