WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable, ROOT\CIMV2

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

Description

Statistics associated with FileTable and non-transacted access

Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable properties

Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable has 38 properties (29 Local, 9 Derived)

NameOriginCIMType
AvgtimedeleteFileTableitemWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimedeleteFileTableitem_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimeFileTableenumerationWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimeFileTableenumeration_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimeFileTablehandlekillWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimeFileTablehandlekill_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimemoveFileTableitemWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimemoveFileTableitem_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimeperfileIOrequestWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimeperfileIOrequest_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimeperfileIOresponseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimeperfileIOresponse_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimerenameFileTableitemWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimerenameFileTableitem_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimetogetFileTableitemWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimetogetFileTableitem_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
AvgtimeupdateFileTableitemWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
AvgtimeupdateFileTableitem_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable19 [uint32]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FileTabledboperationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableenumerationreqsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTablefileIOrequestsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTablefileIOresponsePersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableitemdeletereqsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableitemgetrequestsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableitemmovereqsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableitemrenamereqsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTableitemupdatereqsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTablekillhandleopsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
FileTabletableoperationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerFileTable21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
NameCIM_StatisticalInformation8 [string]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable properties

Local properties (29) of Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable class

…
▲ AvgtimedeleteFileTableitem property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to delete a FileTable item.'
DetailLevel100
DisplayName'Avg time delete FileTable item'
DisplayName009'Avg time delete FileTable item'
HelpIndex0
PerfIndex0
AvgtimedeleteFileTableitem property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimedeleteFileTableitem_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimedeleteFileTableitem_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeFileTableenumeration property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken for a FileTable enumeration request.'
DetailLevel100
DisplayName'Avg time FileTable enumeration'
DisplayName009'Avg time FileTable enumeration'
HelpIndex0
PerfIndex0
AvgtimeFileTableenumeration property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeFileTableenumeration_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimeFileTableenumeration_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeFileTablehandlekill property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to kill a FileTable handle.'
DetailLevel100
DisplayName'Avg time FileTable handle kill'
DisplayName009'Avg time FileTable handle kill'
HelpIndex0
PerfIndex0
AvgtimeFileTablehandlekill property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeFileTablehandlekill_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimeFileTablehandlekill_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimemoveFileTableitem property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to move a FileTable item.'
DetailLevel100
DisplayName'Avg time move FileTable item'
DisplayName009'Avg time move FileTable item'
HelpIndex0
PerfIndex0
AvgtimemoveFileTableitem property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimemoveFileTableitem_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimemoveFileTableitem_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeperfileIOrequest property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) spent handling an incoming file I/O request.'
DetailLevel100
DisplayName'Avg time per file I/O request'
DisplayName009'Avg time per file I/O request'
HelpIndex0
PerfIndex0
AvgtimeperfileIOrequest property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeperfileIOrequest_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimeperfileIOrequest_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeperfileIOresponse property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) spent handling an outgoing file I/O response.'
DetailLevel100
DisplayName'Avg time per file I/O response'
DisplayName009'Avg time per file I/O response'
HelpIndex0
PerfIndex0
AvgtimeperfileIOresponse property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeperfileIOresponse_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimeperfileIOresponse_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimerenameFileTableitem property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to rename a FileTable item.'
DetailLevel100
DisplayName'Avg time rename FileTable item'
DisplayName009'Avg time rename FileTable item'
HelpIndex0
PerfIndex0
AvgtimerenameFileTableitem property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimerenameFileTableitem_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimerenameFileTableitem_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimetogetFileTableitem property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to retrieve a FileTable item.'
DetailLevel100
DisplayName'Avg time to get FileTable item'
DisplayName009'Avg time to get FileTable item'
HelpIndex0
PerfIndex0
AvgtimetogetFileTableitem property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimetogetFileTableitem_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimetogetFileTableitem_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeupdateFileTableitem property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken to update a FileTable item.'
DetailLevel100
DisplayName'Avg time update FileTable item'
DisplayName009'Avg time update FileTable item'
HelpIndex0
PerfIndex0
AvgtimeupdateFileTableitem property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgtimeupdateFileTableitem_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgtimeupdateFileTableitem_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTabledboperationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of database operational events processed by the FileTable store component per second.'
DetailLevel100
DisplayName'FileTable db operations/sec'
DisplayName009'FileTable db operations/sec'
HelpIndex0
PerfDefaultTrue
PerfIndex0
FileTabledboperationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableenumerationreqsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable enumeration requests per second.'
DetailLevel100
DisplayName'FileTable enumeration reqs/sec'
DisplayName009'FileTable enumeration reqs/sec'
HelpIndex0
PerfIndex0
FileTableenumerationreqsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTablefileIOrequestsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of incoming FileTable file I/O requests per second.'
DetailLevel100
DisplayName'FileTable file I/O requests/sec'
DisplayName009'FileTable file I/O requests/sec'
HelpIndex0
PerfIndex0
FileTablefileIOrequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTablefileIOresponsePersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of outgoing file I/O responses per second.'
DetailLevel100
DisplayName'FileTable file I/O response/sec'
DisplayName009'FileTable file I/O response/sec'
HelpIndex0
PerfIndex0
FileTablefileIOresponsePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableitemdeletereqsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable delete item requests per second.'
DetailLevel100
DisplayName'FileTable item delete reqs/sec'
DisplayName009'FileTable item delete reqs/sec'
HelpIndex0
PerfIndex0
FileTableitemdeletereqsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableitemgetrequestsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable retrieve item requests per second.'
DetailLevel100
DisplayName'FileTable item get requests/sec'
DisplayName009'FileTable item get requests/sec'
HelpIndex0
PerfIndex0
FileTableitemgetrequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableitemmovereqsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable move item requests per second.'
DetailLevel100
DisplayName'FileTable item move reqs/sec'
DisplayName009'FileTable item move reqs/sec'
HelpIndex0
PerfIndex0
FileTableitemmovereqsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableitemrenamereqsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable rename item requests per second.'
DetailLevel100
DisplayName'FileTable item rename reqs/sec'
DisplayName009'FileTable item rename reqs/sec'
HelpIndex0
PerfIndex0
FileTableitemrenamereqsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTableitemupdatereqsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable update item requests per second.'
DetailLevel100
DisplayName'FileTable item update reqs/sec'
DisplayName009'FileTable item update reqs/sec'
HelpIndex0
PerfIndex0
FileTableitemupdatereqsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTablekillhandleopsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of FileTable handle kill operations per second.'
DetailLevel100
DisplayName'FileTable kill handle ops/sec'
DisplayName009'FileTable kill handle ops/sec'
HelpIndex0
PerfIndex0
FileTablekillhandleopsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FileTabletableoperationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of table operational events processed by the FileTable store component per second.'
DetailLevel100
DisplayName'FileTable table operations/sec'
DisplayName009'FileTable table operations/sec'
HelpIndex0
PerfIndex0
FileTabletableoperationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable class

…
▲ Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
…
▲ Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Name property
CIMTYPE'string'
Description'The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. '
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Statistics associated with FileTable and non-transacted access'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:FileTable'✓✗✓✓✓
DisplayName009'SQLServer:FileTable'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT38___SYSTEM3✗✗
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8✗✗
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerFileTable

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerFileTable02901--✓
comments powered by Disqus
WUtils.com