SAP ABAP Table MSQ_DYSERV (contains performance measures since sqlserver's last start)

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

Basic Data

Table Category	INTTAB	Structure
Structure	MSQ_DYSERV	Table Relationship Diagram
Short Description	contains performance measures since sqlserver's last start

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SQLUPTIME	☐	MSQDSSQLSC	INT4	INT4	10	0	Number of seconds SQL Server has been running.
2	CPUBUSY	☐	MSQDSCPUBY	INT4	INT4	10	0	Number of seconds CPUs have been busy (sum for all CPUs) .
3	CPUIDLE	☐	MSQDSCPUID	INT4	INT4	10	0	Number of seconds CPUs have been idle (sum for all CPUs) .
4	IOBUSY	☐	MSQDSIOBSY	INT4	INT4	10	0	Number of seconds SQL Server tasks were busy with IO.
5	PCTCPU	☐	MSQDSCPPCT	INT4	INT4	10	0	Percent of time the CPUs have been busy.
6	PCTIDLE	☐	MSQDSIDPCT	INT4	INT4	10	0	Percent of time CPUs have been idle.
7	PCTIO	☐	MSQDSIOPCT	INT4	INT4	10	0	Percent of time SQL Server tasks have beeen busy whit IO.
8	PACKRECD	☐	MSQDSPCKRD	INT4	INT4	10	0	Number of network packets received.
9	PACKSENT	☐	MSQDSPCKST	INT4	INT4	10	0	Number of network packets sent out by SQL Server.
10	CONNECTS	☐	MSQDSCONN	INT4	INT4	10	0	Number of attempted connections to SQL Server.
11	PACKERRORS	☐	MSQDSPCKER	INT4	INT4	10	0	Number of network packets with error since SQL Server start.
12	TOTALREAD	☐	MSQDSTOTRD	INT4	INT4	10	0	Number of disk reads done by SQL Server (physical reads).
13	TOTALWRITE	☐	MSQDSTOTWR	INT4	INT4	10	0	Number of physical disk writes done by SQL Server.
14	TOTALERROR	☐	MSQDSTOTER	INT4	INT4	10	0	Number of disk read or write errors since SQL Server started

History

Last changed by/on	SAP	20110908
SAP Release Created in