XeSqlPkg_optimizer_timeout, ROOT\WMI

Description

Occurs when the optimizer times out either due to spending too much time or hitting a memory limit. Use this event to look at all the queries that are impacted by the optimizer timeout in a particular workload. This can be very useful when tuning a particular workload.

XeSqlPkg_optimizer_timeout - child subclasses in ROOT\WMI

Number of classes:1

…

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
optimizer_timeout	0	7	0	-	-	-	-

XeSqlPkg_optimizer_timeout properties

XeSqlPkg_optimizer_timeout has 1 properties (1 Derived)

Name	Origin	CIMType
Flags	XeSqlPkg	19 [uint32]

Detailed description of XeSqlPkg_optimizer_timeout properties

Derived properties (1) of XeSqlPkg_optimizer_timeout class

…

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

XeSqlPkg_optimizer_timeout Qualifiers

…

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
Description	'Occurs when the optimizer times out either due to spending too much time or hitting a memory limit. Use this event to look at all the queries that are impacted by the optimizer timeout in a particular workload. This can be very useful when tuning a particular workload.'	✗	✗	✓	✗	✓
DisplayName	'optimizer_timeout'	✗	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
Guid	'{2d531280-e102-49a9-a3f9-58ef22f2877f}'	✗	✗	✓	✗	✓
locale	'MS\0x409'	✗	✗	✓	✗	✓

XeSqlPkg_optimizer_timeout System properties

…

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

Similar Classes to XeSqlPkg_optimizer_timeout

Number of classes:13

…

Class name	Childs	Properties	Class Instances	Child Instances	Abstract	Singleton
AspRequestTimeout	0	2	-	-	-	-
lock_timeout	0	21	-	-	-	-
lock_timeout_greater_than_0	0	21	-	-	-	-
locks_lock_timeouts	0	7	-	-	-	-
locks_lock_timeouts_greater_than_0	0	7	-	-	-	-
optimizer_timeout	0	7	-	-	-	-
W3CGIFActivityTimeout	0	3	-	-	-	-
W3CGIFRequestTimeout	0	3	-	-	-	-
W3CGITimeout	0	4	-	-	-	-
XeSqlPkg_lock_timeout	1	1	-	-	-	-
XeSqlPkg_lock_timeout_greater_than_0	1	1	-	-	-	-
XeSqlPkg_locks_lock_timeouts	1	1	-	-	-	-
XeSqlPkg_locks_lock_timeouts_greater_than_0	1	1	-	-	-	-

WUtils.com

Includes&Samples