SAP ABAP Table MSSRESGOVWLGRP (SQL Server Resource Governor Workload Group)
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
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 | MSSRESGOVWLGRP |
Table Relationship Diagram 
|
| Short Description | SQL Server Resource Governor Workload Group |
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 |  GRPID |
MSSGRPID | INT4 | INT4 | 10 | 0 | Resource group ID | ||
| 2 | GRPNAME |
MSSGRPNAME | MSSSYSNAME | CHAR | 128 | 0 | Resource group name | ||
| 3 | IMPRT |
MSSIMPRT | MSSSYSNAME | CHAR | 128 | 0 | Importance of a request in a workload group | ||
| 4 | REQMAXMEMPCT |
MSSRQMAXMEMPCT | INT4 | INT4 | 10 | 0 | Maximum memory grant in percent | ||
| 5 | REQMAXCPUSEC |
MSSRQMAXCPUSEC | INT4 | INT4 | 10 | 0 | Maximum CPU use limit in seconds | ||
| 6 | REQMEMTIMEOUT |
MSSRQMEMTIMEOUT | INT4 | INT4 | 10 | 0 | Memory grant timeout in seconds of a single request | ||
| 7 | MAX_DOP |
MSSMAXDOP | INT4 | INT4 | 10 | 0 | Maximum degree of parallelism for a workload group | ||
| 8 | GRPMAXREQ |
MSSGRPMAXREQ | INT4 | INT4 | 10 | 0 | Maximum number of concurrent requests | ||
| 9 | POOLID |
MSSRGPOOLID | INT4 | INT4 | 10 | 0 | ID of a resource pool |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 720 |
