SAP ABAP Data Element MSSCPUBUSY (SQL Server CPU busy counter)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Data Element | MSSCPUBUSY |
Short Description | SQL Server CPU busy counter |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | MSSCOLLSLOPE | |
Data Type | DEC | Counter or amount field with comma and sign |
Length | 16 | |
Decimal Places | 3 | |
Output Length | 21 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | CPU busy |
Medium | 15 | CPU busy |
Long | 26 | SQLServer CPU busy counter |
Heading | 26 | SQLServer CPU busy counter |
Documentation
Definition
This counter is derived from @@CPUBUSY (see also in the Microsoft books online documentation).
The counter @@CPU_BUSY shows the time since SQL Server was started that the sqlservr.exe executable was busy on a cpu. SAP normalized @@CPU_BUSY by considering @@IDLE and @@IO_BUSY, and calculating on a per second basis.
The value range of this counter is between 0 and the number of processors on the database server.
If the value of the counter is consistently close to the number of processors, a cpu bottleneck may exist.
If the CPU is completely busy with other processes than sqlserver.exe you will not see it here in this busy counter.
Use
Dependencies
Example
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 640 |