sql_statement_recompile, ROOT\WMI

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

sql_statement_recompile properties

sql_statement_recompile has 15 properties (14 Local, 1 Derived)

Name	Origin	CIMType
ActivityId	sql_statement_recompile	13 [object:guid]
Flags	XeSqlPkg	19 [uint32]
FragmentId	sql_statement_recompile	19 [uint32]
line_number	sql_statement_recompile	3 [sint32]
nest_level	sql_statement_recompile	18 [uint16]
object_id	sql_statement_recompile	3 [sint32]
object_name	sql_statement_recompile	8 [string]
object_type	sql_statement_recompile	18 [uint16]
offset	sql_statement_recompile	3 [sint32]
offset_end	sql_statement_recompile	3 [sint32]
recompile_cause	sql_statement_recompile	17 [uint8]
RemainingLength	sql_statement_recompile	19 [uint32]
SequenceNumber	sql_statement_recompile	19 [uint32]
source_database_id	sql_statement_recompile	19 [uint32]
statement	sql_statement_recompile	8 [string]

Detailed description of sql_statement_recompile properties

Local properties (14) of sql_statement_recompile class

▲ ActivityId property
ActivityID	True
CIMTYPE	'object:guid'
Description	'ActivityId'
Extension	'Guid'
read	True
WmiDataId	3
ActivityId property is in 1030 classes of ROOT\WMI and in 1 namespace

▲ FragmentId property
CIMTYPE	'uint32'
Description	'FragmentId'
read	True
WmiDataId	1
FragmentId property is in 1028 classes of ROOT\WMI and in 1 namespace

▲ line_number property
CIMTYPE	'sint32'
read	True
WmiDataId	10
Line_number property is in 11 classes of ROOT\WMI and in 1 namespace

▲ nest_level property
CIMTYPE	'uint16'
read	True
WmiDataId	9
Nest_level property is in 6 classes of ROOT\WMI and in 1 namespace

▲ object_id property
CIMTYPE	'sint32'
read	True
WmiDataId	7
Object_id property is in 86 classes of ROOT\WMI and in 1 namespace

▲ object_name property
CIMTYPE	'string'
Format	'w'
read	True
StringTermination	'NullTerminated'
WmiDataId	13
Object_name property is in 28 classes of ROOT\WMI and in 1 namespace

▲ object_type property
CIMTYPE	'uint16'
read	True
ValueMap	['20801', '17985', '19521', '21825', '2', '1', '20545', '21057', '21313', '19265', '8257', '18241', '20034', '21059', '19523', '21827', '8259', '21571', '17475', '20547', '16964', '21828', '16708', '20036', '21572', '17732', '8260', '19268', '20549', '20037', '8262', '21318', '21574', '17222', '19526', '20038', '21831', '22601', '17993', '21321', '21577', '0', '65536', '22604', '19277', '21581', '4', '20047', '19283', '16975', '18000', '20816', '21072', '19280', '8272', '17232', '20550', '21328', '131072', '18002', '18258', '19538', '21586', '8274', '17235', '20307', '21075', '22099', '19539', '21843', '16723', '20291', '17491', '18259', '8276', '17747', '21587', '20819', '20051', '8275', '18004', '16724', '21076', '22868', '20821', '21333', '8277', '8278', '18263', '19543', '21847', '22611', '8280', '21080']
Values	['ADHOC', 'AGG', 'AKEYLOGIN', 'AKEYUSER', 'ALL', 'ANY', 'APP', 'APPROLE', 'ASM', 'ASYMKEY', 'AUDIT', 'AVAILABILITYGROUP', 'BINDING', 'CERT', 'CERTLOGIN', 'CERTUSER', 'CHECK', 'CONTRACT', 'CREDENTIAL', 'CRYPTOPROVIDER', 'DATABASE', 'DBAUDIT', 'DBAUDITSPEC', 'DBEVTNOT', 'DBTRIG', 'DBXESES', 'DEFAULT', 'DEK', 'ENDPOINT', 'EVTNOTIF', 'FKEY', 'FNSCLASM', 'FNTABASM', 'FTCAT', 'FTSTPLIST', 'FUNCTION', 'GROUPUSER', 'INDEX', 'INLFUNC', 'INLSCLFN', 'INTLTAB', 'INVALID', 'LOCAL', 'LOGIN', 'MASTERKEY', 'MSGTYPE', 'NOTADHOC', 'OBEVTNOT', 'OBFKEY', 'OBJ', 'PFUN', 'PREPARED', 'PRIORITY', 'PRKEY', 'PROC', 'PROCASM', 'PROPERTYLIST', 'PSCHEME', 'REMOTE', 'REPLPROC', 'RG', 'ROLE', 'ROUTE', 'RULE', 'SCHEMA', 'SEQUENCE', 'SERVER', 'SERVICE', 'SQLLOGIN', 'SQLUSER', 'SRVAUDITSPEC', 'SRVCONFIG', 'SRVEVTNOT', 'SRVROLE', 'SRVTRIG', 'SRVXESES', 'STATISTICS', 'SVCQ', 'SYNONYM', 'SYSTAB', 'TABFUNC', 'TRIGASM', 'TRIGGER', 'TYPE', 'UQKEY', 'USER', 'USRTAB', 'VIEW', 'WINGROUP', 'WINLOGIN', 'WINUSER', 'XMLSCHEMA', 'XPROC', 'XREL']
WmiDataId	8
XEMapId	61
Object_type property is in 21 classes of ROOT\WMI and in 1 namespace

▲ offset property
CIMTYPE	'sint32'
read	True
WmiDataId	11
Offset property is in 28 classes of ROOT\WMI and in 5 namespaces

▲ offset_end property
CIMTYPE	'sint32'
read	True
WmiDataId	12
Offset_end property is in 9 classes of ROOT\WMI and in 1 namespace

▲ recompile_cause property
CIMTYPE	'uint8'
read	True
ValueMap	['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16']
Values	['Schema changed', 'Statistics changed', 'Deferred compile', 'Set option change', 'Temp table changed', 'Remote rowset changed', 'For browse permissions changed', 'Query notification environment changed', 'PartitionView changed', 'Cursor options changed', 'Option (recompile) requested', 'Parameterized plan flushed', 'Test plan linearization', 'Plan affecting database version changed', 'QDS plan forcing policy changed', 'QDS plan forcing failed']
WmiDataId	5
XEMapId	33
Recompile_cause property is in 1 class (sql_statement_recompile) of ROOT\WMI and in 1 namespace

▲ RemainingLength property
CIMTYPE	'uint32'
Description	'RemainingLength'
read	True
WmiDataId	2
RemainingLength property is in 1028 classes of ROOT\WMI and in 1 namespace

▲ SequenceNumber property
CIMTYPE	'uint32'
Description	'SequenceNumber'
read	True
WmiDataId	4
SequenceNumber property is in 1038 classes of ROOT\WMI and in 142 namespaces

▲ source_database_id property
CIMTYPE	'uint32'
read	True
WmiDataId	6
Source_database_id property is in 11 classes of ROOT\WMI and in 1 namespace

▲ statement property
CIMTYPE	'string'
Format	'w'
read	True
StringTermination	'NullTerminated'
WmiDataId	14
Statement property is in 22 classes of ROOT\WMI and in 1 namespace

Derived properties (1) of sql_statement_recompile class

▲ Flags property
CIMTYPE	'uint32'
Flags property is in 2953 classes of ROOT\WMI and in 142 namespaces

sql_statement_recompile Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
dynamic	True	✓	✗	✓	✗	✓
EventType	0	✗	✗	✓	✗	✓
EventVersion	1	✗	✗	✓	✗	✓

sql_statement_recompile System properties

Name	Value	Origin	CIMType	Local	Array
__PATH	'\\.\ROOT\WMI:sql_statement_recompile'	___SYSTEM	8	✗	✗
__NAMESPACE	'ROOT\WMI'	___SYSTEM	8	✗	✗
__SERVER	'.'	___SYSTEM	8	✗	✗
__DERIVATION	['XeSqlPkg_sql_statement_recompile', 'XeSqlPkg', 'EventTrace']	___SYSTEM	8	✗	✓
__PROPERTY_COUNT	15	___SYSTEM	3	✗	✗
__RELPATH	'sql_statement_recompile'	___SYSTEM	8	✗	✗
__DYNASTY	'EventTrace'	___SYSTEM	8	✗	✗
__SUPERCLASS	'XeSqlPkg_sql_statement_recompile'	___SYSTEM	8	✗	✗
__CLASS	'sql_statement_recompile'	___SYSTEM	8	✗	✗
__GENUS	1	___SYSTEM	3	✗	✗

Similar Classes to sql_statement_recompile

Number of classes:5

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
cursor_recompile	0	5	0	-	-	-	-
fulltext_query_recompile	0	9	0	-	-	-	-
XeSqlPkg_cursor_recompile	1	1	0	-	-	-	-
XeSqlPkg_fulltext_query_recompile	1	1	0	-	-	-	-
XeSqlPkg_sql_statement_recompile	1	1	0	-	-	-	-

comments powered by Disqus