WUtils.com

XeSqlPkg_sp_cache_miss, 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 a stored procedure is not found in the procedure cache. Frequent occurrences of this event could indicate that SQL Server needs more memory. Use this event along with other sp_cache_* events to troubleshoot issues caused by the procedure cache.

XeSqlPkg_sp_cache_miss - child subclasses in ROOT\WMI

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
sp_cache_miss0110----

XeSqlPkg_sp_cache_miss properties

XeSqlPkg_sp_cache_miss has 1 properties (1 Derived)

NameOriginCIMType
FlagsXeSqlPkg19 [uint32]

Detailed description of XeSqlPkg_sp_cache_miss properties

Derived properties (1) of XeSqlPkg_sp_cache_miss class

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

XeSqlPkg_sp_cache_miss Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Occurs when a stored procedure is not found in the procedure cache. Frequent occurrences of this event could indicate that SQL Server needs more memory. Use this event along with other sp_cache_* events to troubleshoot issues caused by the procedure cache.'✗✗✓✗✓
DisplayName'sp_cache_miss'✗✗✓✗✓
dynamicTrue✓✗✓✗✓
Guid'{1B67518B-9D33-4062-88B4-A574F18C6036}'✗✗✓✗✓
locale'MS\0x409'✗✗✓✗✓

XeSqlPkg_sp_cache_miss System properties

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

Similar Classes to XeSqlPkg_sp_cache_miss

Number of classes:72
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
broker_dialog_transmission_body_dequeue060----
broker_dialog_transmission_body_enqueue070----
broker_dialog_transmission_queue_dequeue0150----
broker_dialog_transmission_queue_enqueue0150----
broker_transmission_acksm_action_fire0120----
broker_transmission_acksm_event_begin0120----
broker_transmission_acksm_event_end0120----
broker_transmission_deliverysm_action_fire0120----
broker_transmission_deliverysm_event_begin0120----
broker_transmission_deliverysm_event_end0120----
broker_transmission_exception0100----
broker_transmission_lazyflusher_processing_begin050----
broker_transmission_lazyflusher_processing_end070----
broker_transmission_lazyflusher_remove0100----
broker_transmission_lazyflusher_submit0100----
broker_transmission_object_delete_begin0100----
broker_transmission_object_delete_end0110----
broker_transmission_object_get0140----
broker_transmission_object_worktable_load_begin0100----
broker_transmission_object_worktable_load_end0110----
broker_transmission_object_worktable_save_begin0100----
broker_transmission_object_worktable_save_end0120----
broker_transmission_timer_armed0110----
broker_transmission_timer_fire0110----
broker_transmission_timer_reset0110----
broker_transmission_timer_set0120----
column_store_object_pool_miss0100----
dq_session_cache_miss0140----
metadata_cache_miss080----
missing_column_statistics060----
missing_join_predicate050----
query_rpc_server_collection_cache_miss0120----
query_rpc_server_runtime_cache_miss0110----
recovery_target_miss090----
remote_dmv_stream_runtime_cache_miss080----
sp_cache_miss0110----
W3CGIFScriptProcessorMissing030----
XeSqlPkg_broker_dialog_transmission_body_dequeue110----
XeSqlPkg_broker_dialog_transmission_body_enqueue110----
XeSqlPkg_broker_dialog_transmission_queue_dequeue110----
XeSqlPkg_broker_dialog_transmission_queue_enqueue110----
XeSqlPkg_broker_transmission_acksm_action_fire110----
XeSqlPkg_broker_transmission_acksm_event_begin110----
XeSqlPkg_broker_transmission_acksm_event_end110----
XeSqlPkg_broker_transmission_deliverysm_action_fire110----
XeSqlPkg_broker_transmission_deliverysm_event_begin110----
XeSqlPkg_broker_transmission_deliverysm_event_end110----
XeSqlPkg_broker_transmission_exception110----
XeSqlPkg_broker_transmission_lazyflusher_processing_begin110----
XeSqlPkg_broker_transmission_lazyflusher_processing_end110----
XeSqlPkg_broker_transmission_lazyflusher_remove110----
XeSqlPkg_broker_transmission_lazyflusher_submit110----
XeSqlPkg_broker_transmission_object_delete_begin110----
XeSqlPkg_broker_transmission_object_delete_end110----
XeSqlPkg_broker_transmission_object_get110----
XeSqlPkg_broker_transmission_object_worktable_load_begin110----
XeSqlPkg_broker_transmission_object_worktable_load_end110----
XeSqlPkg_broker_transmission_object_worktable_save_begin110----
XeSqlPkg_broker_transmission_object_worktable_save_end110----
XeSqlPkg_broker_transmission_timer_armed110----
XeSqlPkg_broker_transmission_timer_fire110----
XeSqlPkg_broker_transmission_timer_reset110----
XeSqlPkg_broker_transmission_timer_set110----
XeSqlPkg_column_store_object_pool_miss110----
XeSqlPkg_dq_session_cache_miss110----
XeSqlPkg_metadata_cache_miss110----
XeSqlPkg_missing_column_statistics110----
XeSqlPkg_missing_join_predicate110----
XeSqlPkg_query_rpc_server_collection_cache_miss110----
XeSqlPkg_query_rpc_server_runtime_cache_miss110----
XeSqlPkg_recovery_target_miss110----
XeSqlPkg_remote_dmv_stream_runtime_cache_miss110----
comments powered by Disqus
WUtils.com