SAP MSQ_DYSERV table - contains performance measures since sqlserver's last start details in SAP

SAP MSQ_DYSERV table summary

Object Name: MSQ_DYSERV
Dictionary Type: Structure
Description: contains performance measures since sqlserver's last start

Field list for MSQ_DYSERV table on an S/4 SAP system

Details

MSQ_DYSERV-SQLUPTIME table field - Number of seconds SQL Server has been running. ▼

Description: Number of seconds SQL Server has been running.
Field Name: SQLUPTIME
Data Element: MSQDSSQLSC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLUPTIME

MSQ_DYSERV-CPUBUSY table field - Number of seconds CPUs have been busy (sum for all CPUs) . ▼

Description: Number of seconds CPUs have been busy (sum for all CPUs) .
Field Name: CPUBUSY
Data Element: MSQDSCPUBY
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPUBUSY

MSQ_DYSERV-CPUIDLE table field - Number of seconds CPUs have been idle (sum for all CPUs) . ▼

Description: Number of seconds CPUs have been idle (sum for all CPUs) .
Field Name: CPUIDLE
Data Element: MSQDSCPUID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPUIDLE

MSQ_DYSERV-IOBUSY table field - Number of seconds SQL Server tasks were busy with IO. ▼

Description: Number of seconds SQL Server tasks were busy with IO.
Field Name: IOBUSY
Data Element: MSQDSIOBSY
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOBUSY

MSQ_DYSERV-PCTCPU table field - Percent of time the CPUs have been busy. ▼

Description: Percent of time the CPUs have been busy.
Field Name: PCTCPU
Data Element: MSQDSCPPCT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTCPU

MSQ_DYSERV-PCTIDLE table field - Percent of time CPUs have been idle. ▼

Description: Percent of time CPUs have been idle.
Field Name: PCTIDLE
Data Element: MSQDSIDPCT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTIDLE

MSQ_DYSERV-PCTIO table field - Percent of time SQL Server tasks have beeen busy whit IO. ▼

Description: Percent of time SQL Server tasks have beeen busy whit IO.
Field Name: PCTIO
Data Element: MSQDSIOPCT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTIO

MSQ_DYSERV-PACKRECD table field - Number of network packets received. ▼

Description: Number of network packets received.
Field Name: PACKRECD
Data Element: MSQDSPCKRD
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PACKRECD

MSQ_DYSERV-PACKSENT table field - Number of network packets sent out by SQL Server. ▼

Description: Number of network packets sent out by SQL Server.
Field Name: PACKSENT
Data Element: MSQDSPCKST
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PACKSENT

MSQ_DYSERV-CONNECTS table field - Number of attempted connections to SQL Server. ▼

Description: Number of attempted connections to SQL Server.
Field Name: CONNECTS
Data Element: MSQDSCONN
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTS

MSQ_DYSERV-PACKERRORS table field - Number of network packets with error since SQL Server start. ▼

Description: Number of network packets with error since SQL Server start.
Field Name: PACKERRORS
Data Element: MSQDSPCKER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PACKERRORS

MSQ_DYSERV-TOTALREAD table field - Number of disk reads done by SQL Server (physical reads). ▼

Description: Number of disk reads done by SQL Server (physical reads).
Field Name: TOTALREAD
Data Element: MSQDSTOTRD
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALREAD

MSQ_DYSERV-TOTALWRITE table field - Number of physical disk writes done by SQL Server. ▼

Description: Number of physical disk writes done by SQL Server.
Field Name: TOTALWRITE
Data Element: MSQDSTOTWR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALWRITE

MSQ_DYSERV-TOTALERROR table field - Number of disk read or write errors since SQL Server started ▼

Description: Number of disk read or write errors since SQL Server started
Field Name: TOTALERROR
Data Element: MSQDSTOTER
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALERROR

View list of all SAP tables(S4H/ECC)

Select data from SAP table