XeSqlPkg_exchange_spill, ROOT\WMI

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

Description

Occurs when the memory communication buffers for a query with multiple Parallelism operators become full, resulting in one of the operators writing to TempDB. If this happens multiple times in a single query plan the query performance is impacted. Use this event in conjunction with any of the *_showplan events to determine which operation in the generated plan is causing the exchange spill using the node_id field

XeSqlPkg_exchange_spill - child subclasses in ROOT\WMI

Number of classes:1
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
exchange_spill070----

XeSqlPkg_exchange_spill properties

XeSqlPkg_exchange_spill has 1 properties (1 Derived)

NameOriginCIMType
FlagsXeSqlPkg19 [uint32]

Detailed description of XeSqlPkg_exchange_spill properties

Derived properties (1) of XeSqlPkg_exchange_spill class

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

XeSqlPkg_exchange_spill Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Occurs when the memory communication buffers for a query with multiple Parallelism operators become full, resulting in one of the operators writing to TempDB. If this happens multiple times in a single query plan the query performance is impacted. Use this event in conjunction with any of the *_showplan events to determine which operation in the generated plan is causing the exchange spill using the node_id field'
DisplayName'exchange_spill'
dynamicTrue
Guid'{9b753fe3-3ee6-46ea-98f9-a586417e071f}'
locale'MS\0x409'

XeSqlPkg_exchange_spill System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\WMI:XeSqlPkg_exchange_spill'___SYSTEM8
__NAMESPACE'ROOT\WMI'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['XeSqlPkg', 'EventTrace']___SYSTEM8
__PROPERTY_COUNT1___SYSTEM3
__RELPATH'XeSqlPkg_exchange_spill'___SYSTEM8
__DYNASTY'EventTrace'___SYSTEM8
__SUPERCLASS'XeSqlPkg'___SYSTEM8
__CLASS'XeSqlPkg_exchange_spill'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to XeSqlPkg_exchange_spill

Number of classes:3
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
exchange_spill070----
query_execution_batch_hash_join_spilled0110----
XeSqlPkg_query_execution_batch_hash_join_spilled110----
comments powered by Disqus
WUtils.com