SAP ABAP Data Element - Index M, page 25
Data Element - M
| # | Data Element | Short Description | Domain | Data Type |
|---|---|---|---|---|
 |
|
|
|
|
| 1 |  MSSLOCKMEM |
SQL Server Memory currently used for locking |  MSSCOLLMEMSIZE |
DEC |
| 2 | MSSLOCKMODE |
req_mod from syslockinfo for blocking/blocked lock entry | CHAR | |
| 3 | MSSLOCKPG |
MS SQL Server locked page number | INT4 |
INT4 |
| 4 | MSSLOCKREQ |
Number of lock requests per second | MSSCOLLSLOPE |
DEC |
| 5 | MSSLOCKRSC |
Textual description of a lock resource from syslockinfo | CHAR | |
| 6 | MSSLOCKTXT |
MS SQL Server lock description text | TEXT35 |
CHAR |
| 7 | MSSLOCKTYP |
MS SQL Server lock type number | INT2 |
INT2 |
| 8 | MSSLOCKWAITMS |
Average lock wait time per request | MSSCOLLSLOPE |
DEC |
| 9 | MSSLOGFLUSHES |
Number of log flushes | MSSCOLLSLOPE |
DEC |
| 10 | MSSLOGFLUSHS |
Log flushes per sec | MSSCOLLSLOPE |
DEC |
| 11 | MSSLOGFLUSHWAIT |
Wait time per log flush | MSSCOLLSLOPE |
DEC |
| 12 | MSSLOGFREE |
MSS Server DB Log free size | INT4 |
INT4 |
| 13 | MSSLOGINID |
MS SQL Server login ID | INT2 |
INT2 |
| 14 | MSSLOGINNAME |
Login name | MSSSYSNAME |
CHAR |
| 15 | MSSLOGRDFLAG |
High logical reads for this statement | CHAR1 |
CHAR |
| 16 | MSSLOGREBUILDS |
Number of database log rebuilds | INT4 | |
| 17 | MSSLOGSCANFRAG |
Logical scan fragmentation | DEC | |
| 18 | MSSLOGSIZE |
MSS Server log size | INT4 |
INT4 |
| 19 | MSSLOGWRFLAG |
Statement has high logical writes | CHAR1 |
CHAR |
| 20 | MSSLOGWRITEWAIT |
Wait time per log write request | MSSCOLLSLOPE |
DEC |
| 21 | MSSLOWSIGSTATE |
Low memory signal state | INT1 | |
| 22 | MSSLRUNDAT |
MS SQL Server last run date for SQL task | INT4 |
INT4 |
| 23 | MSSLRUNTIM |
MS SQL Server last task run time | INT4 |
INT4 |
| 24 | MSSLSCAT |
OLE DB catalog property of a linked server | MSSSYSNAME |
CHAR |
| 25 | MSSLSDS |
OLE DB data source property belonging to a linked server | CHAR | |
| 26 | MSSLSLOC |
OLE DB location property of a linked server | CHAR | |
| 27 | MSSLSPRODUCT |
Product name of the linked server. | CHAR | |
| 28 | MSSLSPROVSTR |
OLE DB provider string property of a linked server | CHAR | |
| 29 | MSSLSPRVDNM |
Name of the OLE DB provider managing access to linked server | CHAR | |
| 30 | MSSLSTRNDT |
Sql agent job - Last run Date | DATS | |
| 31 | MSSLSTRNTM |
Agent job's last run time | TIMS | |
| 32 | MSSLSTSYSLOOKUP |
Index usage: Time of last system lookup | CHAR | |
| 33 | MSSLSTSYSSCAN |
Index usage: Time of last system scan | CHAR | |
| 34 | MSSLSTSYSSEEK |
Index usage: Time of last system seek | CHAR | |
| 35 | MSSLSTSYSUPDATE |
Index usage: Time of last system update | CHAR | |
| 36 | MSSLSTULOOKUP |
Index usage: Last user lookup (sql datetime) | CHAR | |
| 37 | MSSLSTUSCAN |
Index usage: Last user scan (sql datetime) | CHAR | |
| 38 | MSSLSTUSEEK |
Index usage: Last user seek (sql datetime) | CHAR | |
| 39 | MSSLSTUUPDATE |
Index usage: Last user update (sql datetime) | CHAR | |
| 40 | MSSMAINVER |
MS SQL Server database version (main number) | TEXT2 |
CHAR |
| 41 | MSSMAXCLRTIME |
Maximum CLR time consumed by this plan | DEC | |
| 42 | MSSMAXDOP |
Maximum degree of parallelism for a workload group | INT4 |
INT4 |
| 43 | MSSMAXELAPSEDTIME |
Maximum elapsed time in microseconds | DEC | |
| 44 | MSSMAXIMUM |
Maximum of sp_configure parameter | CHAR11 |
CHAR |
| 45 | MSSMAXLOGICALREADS |
Maximum number of logical reads this plan has ever performed | DEC | |
| 46 | MSSMAXLOGWRITES |
Maximum logical writes for this plan for a single execution | DEC | |
| 47 | MSSMAXMEM |
Max memory limit for SQL Server | MSSCOLLMEMSIZE |
DEC |
| 48 | MSSMAXPHYSREADS |
Maximum number of physical reads for this plan | DEC | |
| 49 | MSSMAXPHYSWRITES |
Maximum physical writes for this plan for a single execution | DEC | |
| 50 | MSSMAXQROWS |
Maximun number of rows returned for a query plan | DEC | |
| 51 | MSSMAXRCSZ |
Maximum record size in that level of the index. | INT4 | |
| 52 | MSSMAXSIZE |
File size limit in MB configured in SQL Server. | CHAR10 |
CHAR |
| 53 | MSSMAXWORKERTIME |
Maximum CPU time consumed by this plan | DEC | |
| 54 | MSSMBRPHSTART |
MBytes read per hour since SQL Server was started | INT4 |
INT4 |
| 55 | MSSMBWPHSTART |
MBytes written per hour since SQL Server was started | INT4 |
INT4 |
| 56 | MSSMCALLOCKB |
Allocated KB for memory component | DEC | |
| 57 | MSSMCALLOCPCT |
Allocated memory percentage | DEC | |
| 58 | MSSMCAWE |
AWE allocated kb | DEC | |
| 59 | MSSMCMP |
Memory component type from sys.dm_os_memory_clerks | CHAR | |
| 60 | MSSMCMPNM |
Component name from sys.dm_os_memory_clerks | CHAR | |
| 61 | MSSMCSHCOMM |
Shared memory committed by a memory clerk | DEC | |
| 62 | MSSMCSHRESV |
Shared memory reserved by a memory clerk | DEC | |
| 63 | MSSMCVCOMM |
Virtual memory committed | DEC | |
| 64 | MSSMCVRESV |
Reserved virtual memory | DEC | |
| 65 | MSSMDSETDS |
MS Sql Server - Backup media set description | MSSSYSNAME |
CHAR |
| 66 | MSSMEMOPT |
Memory options for SQL Server/NT (3 GB, AWE) | CHAR | |
| 67 | MSSMEMSTATEDESC |
Memory state description | CHAR | |
| 68 | MSSMEMUSE |
MS SQL Server # of 2K pages used in procedure cache | INT4 |
INT4 |
| 69 | MSSMERGEPUB |
Flag for merge replication | FLAG |
CHAR |
| 70 | MSSMINCLRTIME |
Minimum CLR time consumed by this plan | DEC | |
| 71 | MSSMINELAPSEDTIME |
Minimum elapsed time in microseconds | DEC | |
| 72 | MSSMINIMUM |
Minimum of sp_configure parameter | CHAR11 |
CHAR |
| 73 | MSSMINLOGICALREADS |
Minimum number of logical reads this plan has ever performed | DEC | |
| 74 | MSSMINLOGWRITES |
Minimum logical writes for this plan for a single execution | DEC | |
| 75 | MSSMINMAX |
Maximum memory setting in sp_configure | DEC | |
| 76 | MSSMINMEM |
Minimum memory setting in sp_configure | MSSCOLLMEMSIZE |
DEC |
| 77 | MSSMINPHYSREADS |
Minimum number of physical reads for this plan | DEC | |
| 78 | MSSMINPHYSWRITES |
Minimum physical writes for this plan for a single execution | DEC | |
| 79 | MSSMINQROWS |
Minimum number of rows returned for a query plan | DEC | |
| 80 | MSSMINRCSZ |
Minimum record size in that level of the index. | INT4 | |
| 81 | MSSMINWORKERTIME |
Minimum CPU time consumed by this plan | DEC | |
| 82 | MSSMIRRFLG |
MS SQL Server mirror flag (shows that a device is mirrored) | CHAR1 |
CHAR |
| 83 | MSSMODDATE |
MS SQL Server task modification date and time | TEXT20 |
CHAR |
| 84 | MSSMODE |
Mode for executing sys.dm_db_index_physical_stats | MSSSYSNAME |
CHAR |
| 85 | MSSMSG |
Deadlock message | MSSMSG |
CHAR |
| 86 | MSSMSGID |
MS SQL Server message ID | INT4 |
INT4 |
| 87 | MSSMSPAPERIOD |
IOSTALLS ms per read during last measurement period | INT4 |
INT4 |
| 88 | MSSMSPASTART |
IOSTALLS ms per read derived from ::fn_virtualfilestats | INT4 |
INT4 |
| 89 | MSSNAME |
Name of sp_configure parameter | CHAR35 |
CHAR |
| 90 | MSSNECOLS |
list of columns that contribute to inequality predicates | MSSIDXRECCOLS |
CHAR |
| 91 | MSSNETRANSPORT |
The network transport type used by the connection | CHAR80 |
CHAR |
| 92 | MSSNONLEAFALLOCCNT |
Index op stats: Count of non leaf-level page allocations | DEC | |
| 93 | MSSNONLEAFDELCNT |
Index op stats: Count of deletes above the leaf level | DEC | |
| 94 | MSSNONLEAFINSCNT |
Index op stats: Count of inserts above the leaf level | DEC | |
| 95 | MSSNONLEAFPAGEMERGECNT |
Index op stats: Count of page merges above the leaf level | DEC | |
| 96 | MSSNONLEAFUPDCNT |
Index op stats: Count of updates above the leaf level | DEC | |
| 97 | MSSNRUNDAT |
MS SQL Server next task run date | INT4 |
INT4 |
| 98 | MSSNRUNTIM |
MS SQL Server next task run time | INT4 |
INT4 |
| 99 | MSSNUMINDEXES |
Number of indexes of user tables | INT4 | |
| 100 | MSSNUMINDS |
Number of indexes of a table | INT4 | |
| 101 | MSSNUMLOGREADS |
Total number of reads performed | MSQBIGINT |
DEC |
| 102 | MSSNUMPROCS |
Number of stored procedures created in DBI | INT4 | |
| 103 | MSSNUMREADS |
Total number of reads performed by a session and request | MSQBIGINT |
DEC |
| 104 | MSSNUMRECD |
MS SQL Server peformance server: number of records | INT2 |
INT2 |
| 105 | MSSNUMROWS |
Number of rows | DEC | |
| 106 | MSSNUMROWSDL |
Number of rows delta | DEC | |
| 107 | MSSNUMRPERIOD |
Number of reads during the last measurement period | INT4 |
INT4 |
| 108 | MSSNUMSKIP |
MS SQL Server number of task skips | INT4 |
INT4 |
| 109 | MSSNUMSTATS |
Number of statistics of a table | INT4 | |
| 110 | MSSNUMTABLES |
Number of user tables | INT4 | |
| 111 | MSSNUMWPERIOD |
Number of writes during the last measurement period | INT4 |
INT4 |
| 112 | MSSNUMWRITES |
Total number of writes performed | MSQBIGINT |
DEC |
| 113 | MSSNXRNDT |
Sql agent job - Next run Date | DATS | |
| 114 | MSSNXRNTM |
SQL Agent Job's Next Run Time | TIMS | |
| 115 | MSSOBJCNT |
Object count | INT4 | |
| 116 | MSSOBJECT |
Object name | MSSSYSNAME |
CHAR |
| 117 | MSSOBJID |
Object id | INT4 | |
| 118 | MSSOBJNAME |
MS SQL Server object name | TEXT30 |
CHAR |
| 119 | MSSOBJSRC |
MSSQL Multiconnect : Object source schema | MSSSYSNAME |
CHAR |
| 120 | MSSOBJSZ |
Total object size | DEC | |
| 121 | MSSOBJTYPE |
Object type | CHAR | |
| 122 | MSSOBJTYPNAME |
Type of object | CHAR | |
| 123 | MSSOPENRES |
Number of open result sets for the SQL Server process | INT4 | |
| 124 | MSSOPENTRAN |
Number of open transactions for the SQL Server process | INT4 | |
| 125 | MSSOPTMEM |
Memory for SQL Server Optimizer | MSSCOLLMEMSIZE |
DEC |
| 126 | MSSOSCOMMITMEM |
Committed memory in the memory manager in MB | DEC | |
| 127 | MSSOSCOMMITTRGMEM |
Committed target memory | DEC | |
| 128 | MSSOSINSTDATE |
Date when the operating system was installed | SYDATS |
DATS |
| 129 | MSSOSLASTBOOTDT |
Date of last restart of the operating system | SYDATS |
DATS |
| 130 | MSSOSLASTBOOTTM |
Time of last restart of the operating system | SYTIME |
TIMS |
| 131 | MSSOSPAGEFILEFREE |
Free page file space in MB | DEC | |
| 132 | MSSOSPAGEFILESZ |
Page file size in MB | DEC | |
| 133 | MSSOSPHYSMEM |
Physical memory in MB | DEC | |
| 134 | MSSOSVIRTMEM |
Virtual memory available to process in user mode | DEC | |
| 135 | MSSOVERFLOWRSRV |
Overflow reserved size | DEC | |
| 136 | MSSOVERFLOWSZ |
Overflow data size | DEC | |
| 137 | MSSOWNIND |
Owner index name | CHAR | |
| 138 | MSSOWNMODE |
Owner mode | CHAR | |
| 139 | MSSOWNOBJ |
Owner object name | CHAR | |
| 140 | MSSPACKSZ |
SQL Server packet size | INT4 | |
| 141 | MSSPADIND |
PAD_INDEX flag | MSSPADIND |
CHAR |
| 142 | MSSPAEXAL |
Number of extents allocated to database objects | DEC | |
| 143 | MSSPAEXDE |
Number of extents deallocated in a database | DEC | |
| 144 | MSSPAFULLS |
Number of unrestricted base table or index scans | DEC | |
| 145 | MSSPAGCNT |
Total number of index or data pages | DEC | |
| 146 | MSSPAGEIOLTCHWAITCNT |
Index op stats: I/O page latch wait count | DEC | |
| 147 | MSSPAGEIOLTCHWAITMS |
Index op stats: I/O page latch wait in ms | DEC | |
| 148 | MSSPAGELCKCNT |
Index op stats: Page lock count | DEC | |
| 149 | MSSPAGELCKWAITCNT |
Index op stats: Page lock wait count | DEC | |
| 150 | MSSPAGELCKWAITMS |
Index op stats: Page lock wait in milliseconds | DEC | |
| 151 | MSSPAGELOCKS |
Page locks allowed | CHAR | |
| 152 | MSSPAGELTCHWAITCNT |
Index op stats: Latch wait count | DEC | |
| 153 | MSSPAGELTCHWAITMS |
Index op stats: Latch waits ms | DEC | |
| 154 | MSSPAGEREADSPLK |
Page reads per buffer lookup | MSSCOLLSLOPE |
DEC |
| 155 | MSSPAIDXSR |
Number of index searches | DEC | |
| 156 | MSSPAPGAL |
Number of pages allocated to database objects | DEC | |
| 157 | MSSPAPGDE |
Number of pages deallocated in a database | DEC | |
| 158 | MSSPAPGSPL |
Number of index page splits in a database | DEC | |
| 159 | MSSPAPRBSN |
Number of probe scans in a database | DEC | |
| 160 | MSSPARAVAL |
MS SQL Server profile parameters | CHAR60 |
CHAR |
| 161 | MSSPARENTCONNID |
SQL Server parent connection id | MSSUNIQIDENT |
CHAR |
| 162 | MSSPARNAME |
MS SQL-Server name of a stored procedure parameter | TEXT30 |
CHAR |
| 163 | MSSPARNGSN |
Number of range scans through indexes | DEC | |
| 164 | MSSPART |
MS SQL Server partition name | CHAR10 |
CHAR |
| 165 | MSSPARTCRDT |
Date of creation of a table partition | DATS |
DATS |
| 166 | MSSPARTCRTM |
Time created | TIME |
TIMS |
| 167 | MSSPARTDATATYPE |
Partitioning data type name | MSSSYSNAME |
CHAR |
| 168 | MSSPARTDIR |
Partitioning direction | CHAR | |
| 169 | MSSPARTFANOUT |
Number of partitions created by a partitioning function | INT4 |
INT4 |
| 170 | MSSPARTFUNC |
Partition function name | MSSSYSNAME |
CHAR |
| 171 | MSSPARTHIGHBOUND |
Description of the high boundary of a partition | MSSPARTVAL |
CHAR |
| 172 | MSSPARTIALSQL |
First 50 characters of a SQL Server statement | TEXT50 |
CHAR |
| 173 | MSSPARTITIONVAL |
Partition Threshold Value for MS SQL Server | CHAR | |
| 174 | MSSPARTLOWBOUND |
Description of the low boundary of a partition | MSSPARTVAL |
CHAR |
| 175 | MSSPARTMODDT |
Date of modification of a table partition | DATS |
DATS |
| 176 | MSSPARTMODTM |
Time modified | TIME |
TIMS |
| 177 | MSSPARTNUMROWS |
Number of rows in a partition (possibly '-') therefore char | CHAR | |
| 178 | MSSPARTORD |
Partition ordinal (or ID) | INT2 |
INT2 |
| 179 | MSSPARTPARATYP |
Data Type of a Partition Parameter (INT4, CHAR, DEC) | MSSPARTPARADOM |
CHAR |
| 180 | MSSPARTPRIMKEY |
Possible interface vals: whether or not primary key created | MSSPARTPRIMKEY |
CHAR |
| 181 | MSSPARTRIGHT |
Indicator: Whether Partitioning is Right-Aligned | MSSPARTTYPEDOM |
CHAR |
| 182 | MSSPARTSCHEME |
Partitioning scheme name | MSSSYSNAME |
CHAR |
| 183 | MSSPARTTYPE |
Type of Partitioning (such as Range, Hash, ...) | MSSPARTDOM |
CHAR |
| 184 | MSSPARTVALMAX |
Max value stored in a partition for the partitioning field | MSSPARTVAL |
CHAR |
| 185 | MSSPARTVALMIN |
Minimum val stored in a partition for the partitioning field | MSSPARTVAL |
CHAR |
| 186 | MSSPATH |
UNC path to a file used by SQL Server | MSSCSC255 |
CHAR |
| 187 | MSSPAWFCRE |
Number of work files created | DEC | |
| 188 | MSSPAWTCRE |
Number of work tables created | DEC | |
| 189 | MSSPBCACHT |
Percentage of pages found in the buffer cache | DEC | |
| 190 | MSSPBCACSZ |
Size in KB of the procedure cache, including unused space. | DEC | |
| 191 | MSSPBCOMIT |
Number of committed pages in cache. | DEC | |
| 192 | MSSPBDATAC |
Size in KB of the data cache, including unused space | DEC | |
| 193 | MSSPBFREBF |
Number of free pages available in cache. | DEC | |
| 194 | MSSPBLZWTS |
Number of pages written by the lazy writer to disk. | DEC | |
| 195 | MSSPBPGRDS |
Number of physical page reads | DEC | |
| 196 | MSSPBPGWRT |
Number of physical page writes | DEC | |
| 197 | MSSPBRAPGS |
Number of pages read in anticipation of use. | DEC | |
| 198 | MSSPBSTPCT |
Number of buffer pages taken for other memory requirements | DEC | |
| 199 | MSSPBUFREQ |
Number of requests to find a page in the buffer pool. | DEC | |
| 200 | MSSPC |
Space character in message line | CHAR1 |
CHAR |
| 201 | MSSPCOBJCT |
Number of objects stored in the procedure cache. | DEC | |
| 202 | MSSPCPAGES |
Number of pages used by this object type in the cache. | DEC | |
| 203 | MSSPCRATIO |
Procedure cache hit ratio as percentage. | DEC | |
| 204 | MSSPCTCLRTIME |
Percentage of overall CLR time | DEC | |
| 205 | MSSPCTELAPSEDTIME |
Percentage of all server elapsed times | DEC | |
| 206 | MSSPCTEXECCNT |
Percentage of server total execution counts | DEC | |
| 207 | MSSPCTLOGICALREADS |
Percent of server wide logical reads | DEC | |
| 208 | MSSPCTLOGWRITES |
Percentage of all logical writes | DEC | |
| 209 | MSSPCTPHYSREADS |
Percent of all physical reads | DEC | |
| 210 | MSSPCTWORKERTIME |
Percent of total worker time | DEC | |
| 211 | MSSPCTYPE |
Type of object in SQL Server procedure cache. | CHAR40 |
CHAR |
| 212 | MSSPCUSECT |
Number of times an object of this type has been used. | DEC | |
| 213 | MSSPDBNAME |
MS SQL Server: Database name | TEXT30 |
CHAR |
| 214 | MSSPGLATCHWAIT |
Wait time per buffer page latch request | MSSCOLLSLOPE |
DEC |
| 215 | MSSPGLIFEEXP |
Page life expectancy | DEC | |
| 216 | MSSPGWRITEWAIT |
Wait time per page write request | MSSCOLLSLOPE |
DEC |
| 217 | MSSPHDEVNM |
MS SQL Server physical device name | TEXT128 |
CHAR |
| 218 | MSSPHYNAME |
MS SQL Server physical device name | MSSTEXT127 |
CHAR |
| 219 | MSSPHYONLY |
MSS - DBCC Check Physical only option | CHAR1 |
CHAR |
| 220 | MSSPHYRDFLAG |
Statement included because of high physical reads | CHAR1 |
CHAR |
| 221 | MSSPHYSIO |
MS SQL Server cumulative physical I/O | INT4 |
INT4 |
| 222 | MSSPHYSMEM |
Physical available memory | MSSCOLLMEMSIZE |
DEC |
| 223 | MSSPHYSREADSDB |
Physical reads per database in a second | MSSCOLLSLOPE |
DEC |
| 224 | MSSPHYSREADSSRV |
Physical reads for whole server in a second | MSSCOLLSLOPE |
DEC |
| 225 | MSSPHYSWRITESDB |
Physical writes per database in a second | MSSCOLLSLOPE |
DEC |
| 226 | MSSPHYSWRITESSRV |
Physical writes for whole server in a second | MSSCOLLSLOPE |
DEC |
| 227 | MSSPLANCRDT |
Plan guide creation date | CHAR | |
| 228 | MSSPLANCRETIME |
MS SQL Server time at which the plan was compiled. | TEXT20 |
CHAR |
| 229 | MSSPLANDISABLED |
Plan is disabled | INT1 |
INT1 |
| 230 | MSSPLANEXECTIME |
MS SQL Server: Last time at which the plan was executed. | TEXT20 |
CHAR |
| 231 | MSSPLANGENNUM |
Number of times this plan has been recompiled | DEC | |
| 232 | MSSPLANGUIDE |
Planguide name | MSSSYSNAME |
CHAR |
| 233 | MSSPLANGUIDEID |
Plan guide ID | INT4 |
INT4 |
| 234 | MSSPLANHANDLE |
handle pointing to plan used in execution of sql stmt/proc | MSSHANDLE |
CHAR |
| 235 | MSSPLANHINTS |
Plan guide hints | CHAR | |
| 236 | MSSPLANMODDT |
Plan guide modification date | CHAR | |
| 237 | MSSPLANPARAMS |
Plan guide parameters | CHAR | |
| 238 | MSSPLANQUERY |
Plan guide query text | CHAR | |
| 239 | MSSPLANSCOPETYPE |
Scope type | INT4 |
INT4 |
| 240 | MSSPLANSCOPETYPEDESC |
Plan guide scope type description | CHAR | |
| 241 | MSSPLARG |
MSS: Plan arguments | CHAR | |
| 242 | MSSPLATTRVAL |
Plan attribute value | CHAR | |
| 243 | MSSPLAVGROWSZ |
MSS: Plan average row size | INT4 | |
| 244 | MSSPLAVGWT |
Number of SQL batch requests received by server. | DEC | |
| 245 | MSSPLCKRQS |
Number of new lock requests or lock conversion requests. | DEC | |
| 246 | MSSPLCKWTS |
Number of lock requests that resulted in a wait | DEC | |
| 247 | MSSPLCKWTT |
Total wait time in seconds for locks (up to last second). | DEC | |
| 248 | MSSPLDEFVAL |
MSS: Plan defined values | CHAR | |
| 249 | MSSPLESTCPU |
MSS: Plan estimated CPU | FLTP | |
| 250 | MSSPLESTEXECS |
MSS: Plan estimated executions | DEC | |
| 251 | MSSPLESTIO |
MSS: Plan estimated IO | FLTP | |
| 252 | MSSPLESTROWS |
MSS: Plan estimated rows | FLTP | |
| 253 | MSSPLLOGOP |
MSS: Plan logical operation name | CHAR | |
| 254 | MSSPLNODEID |
MSS: Plan node ID | INT4 |
INT4 |
| 255 | MSSPLNUMDL |
Number of lock requests that resulted in a deadlock. | DEC | |
| 256 | MSSPLOCKTO |
Number of lock requests that have timed out | DEC | |
| 257 | MSSPLOPTYPE |
MSS: Plan operation type | CHAR | |
| 258 | MSSPLOUTLST |
MSS: Plan output list | CHAR | |
| 259 | MSSPLPARALLEL |
MSS: Plan parallel flag | CHAR | |
| 260 | MSSPLPARENT |
MSS: Plan parent node | INT4 |
INT4 |
| 261 | MSSPLPHYSOP |
MSS:Plan physical operation name | CHAR | |
| 262 | MSSPLSTMTID |
MSS: Plan statement ID | INT4 |
INT4 |
| 263 | MSSPLTREECOST |
MSS: Plan total subtree cost | FLTP | |
| 264 | MSSPLWARN |
MSS: Plan warnings | CHAR | |
| 265 | MSSPMCACM |
Amount of memory being used for dynamic SQL cache in KB | DEC | |
| 266 | MSSPMCONN |
Amount of dynamic memory the server is using for connections | DEC | |
| 267 | MSSPMGWSPM |
Amount of memory granted to executing processes in KB | DEC | |
| 268 | MSSPMLCKM |
Amount of dynamic memory used for locks in KB | DEC | |
| 269 | MSSPMMWSPM |
Maximum amount of memory available for executing SQL process | DEC | |
| 270 | MSSPMOPMEM |
Amount of memory SQL Server is using for query optimization | DEC | |
| 271 | MSSPMTARSM |
Amount of memory SQL Server is willing to consume in KB | DEC | |
| 272 | MSSPMTTLSM |
Amount of memory SQL Server is currently using in KB. | DEC | |
| 273 | MSSPOLCRBY |
Created by | MSSSYSNAME |
CHAR |
| 274 | MSSPOLCRDT |
Policy creation date | CHAR | |
| 275 | MSSPOLDESC |
Policy description | CHAR | |
| 276 | MSSPOLDTMOD |
Date modified | CHAR | |
| 277 | MSSPOLEXEMODE |
Policy execution mode | CHAR | |
| 278 | MSSPOLISENABLED |
Is enabled flag | FLAG |
CHAR |
| 279 | MSSPOLMODBY |
Modified by | MSSSYSNAME |
CHAR |
| 280 | MSSPOLNAME |
Policy name | MSSSYSNAME |
CHAR |
| 281 | MSSPOOLNAME |
Resource pool name | MSSSYSNAME |
CHAR |
| 282 | MSSPRCAREA |
MS SQL Server: Stored procedure application area | MSSPRCAREA |
CHAR |
| 283 | MSSPRCCOMP |
Percentage complete | DEC | |
| 284 | MSSPRCTEXT |
MS SQL Server: Stored procedure source code | MSSPRCTEXT |
CHAR |
| 285 | MSSPREPEXCEP |
Exception field for Prepare on the application Server list | CHAR | |
| 286 | MSSPRFCMD |
Command for SQL Server cache profile switch | MSSPRFCMD |
INT1 |
| 287 | MSSPRGNAME |
Name of the application program which owns the connection | TEXT30 |
CHAR |
| 288 | MSSPROBESCANS |
Number of probe scans per second | MSSCOLLSLOPE |
DEC |
| 289 | MSSPROC |
Stored procedure name | MSSSYSNAME |
CHAR |
| 290 | MSSPROCCACHESZ |
Size of the SQL Server procedure cache | MSSCOLLMEMSIZE |
DEC |
| 291 | MSSPROCED |
MS SQL Server: Stored procedure name | MSSPROCED |
CHAR |
| 292 | MSSPROPNAME |
Table Property Name | CHAR | |
| 293 | MSSPROPVALUE |
MSS Table property value | CHAR | |
| 294 | MSSPROTYPE |
The network transport protocol used by the connection | CHAR80 |
CHAR |
| 295 | MSSPSALTWT |
Average wait time in ms for latch requests that waited. | DEC | |
| 296 | MSSPSAUTO |
Number of auto-parameterization attempts | DEC | |
| 297 | MSSPSBATCH |
Number of SQL batch requests received by server. | DEC | |
| 298 | MSSPSLTHWT |
Number of latch requests that had to wait before granted. | DEC | |
| 299 | MSSPSQLCMP |
Number of SQL compilations | DEC | |
| 300 | MSSPSUSCON |
Number of user connections to the SQL Server system | DEC | |
| 301 | MSSPUBLISHED |
is_published from sys.objects | FLAG |
CHAR |
| 302 | MSSRANGESCANCNT |
Index op stats: Count of range and table scans | DEC | |
| 303 | MSSRANGESCANS |
Number of range scans per second | MSSCOLLSLOPE |
DEC |
| 304 | MSSRATOBJ |
MSSQL: RAT Object Name | CHAR | |
| 305 | MSSRAWDATALINE |
Holds raw data chunk from MSS SQL Profiler file | RAW | |
| 306 | MSSREADAHEAD |
Page reads per read ahead | MSSCOLLSLOPE |
DEC |
| 307 | MSSRECCNT |
Number of records in index | DEC | |
| 308 | MSSRELDEP |
MSSQL: Indicator for Release-Dependence of SQL Scripts | CHAR | |
| 309 | MSSRELEASE |
MSSQL : SQL Server Release string >> XX.YYY.ZZZZ << | CHAR | |
| 310 | MSSREPLFILT |
Flag for replication filter | FLAG |
CHAR |
| 311 | MSSREQCONNID |
SQL Server connection id | MSSUNIQIDENT |
CHAR |
| 312 | MSSREQCPU |
CPU time utilized by a request | INT4 | |
| 313 | MSSREQCPUTIME |
CPU time for a request | INT4 |
INT4 |
| 314 | MSSREQDATE |
Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS | CHAR | |
| 315 | MSSREQMODE |
Granted mode or mode being requested | CHAR | |
| 316 | MSSREQNUMLOGRDS |
number of reads performed by a request | MSQBIGINT |
DEC |
| 317 | MSSREQNUMREADS |
number of reads performed by the request | MSQBIGINT |
DEC |
| 318 | MSSREQNUMWRITES |
number of writes performed in a request | MSQBIGINT |
DEC |
| 319 | MSSREQOWNTYP |
req_refcnt from syslockinfo for blocking/blocked lock entry | CHAR | |
| 320 | MSSREQREFCNT |
req_refcnt from syslockinfo for blocking/blocked lock entry | INT4 | |
| 321 | MSSREQSCHEDULERID |
ID of the scheduler used for the request | INT4 | |
| 322 | MSSREQSID |
Session ID associated with the request being processed | INT4 | |
| 323 | MSSREQSPID |
MS SQL Server process ID | INT2 |
INT2 |
| 324 | MSSREQSTATUS |
Status: GRANTED, CONVERT, or WAIT. | CHAR | |
| 325 | MSSREQTTL |
Total elapsed time utilized by a request | INT4 | |
| 326 | MSSREQUESTID |
SQL Server Request ID | INT4 | |
| 327 | MSSRESDATE |
MS SQL Server: Restoration date and time | CHAR20 |
CHAR |
| 328 | MSSRESDESC |
Lock resource description (dm_tran_locks) | CHAR | |
| 329 | MSSRESIMTX |
MS SQL Server number of reserved image + text pages of table | INT4 |
INT4 |
| 330 | MSSRESSIZE |
Reserved size in KB | DEC | |
| 331 | MSSRESSIZEDL |
Reserved size delta in KB | DEC | |
| 332 | MSSRETRIES |
MS SQL Server task execution retries | INT4 |
INT4 |
| 333 | MSSRETRYAT |
MS SQL Server task execution retry attempts | INT4 |
INT4 |
| 334 | MSSRETRYDE |
MS SQL Server task retry delay | INT4 |
INT4 |
| 335 | MSSRFCDES |
MSSQL: RFC Destination to Remote Comparison | RFCDEST |
CHAR |
| 336 | MSSRGMAXCPUPCT |
Maximum average CPU bandwidth for all requests | INT4 |
INT4 |
| 337 | MSSRGMAXMEMPCT |
Percentage of total server memory allowed in resource pool | INT4 |
INT4 |
| 338 | MSSRGMINCPUPCT |
Guaranteed average CPU bandwidth for all requests | INT4 |
INT4 |
| 339 | MSSRGMINMEMPCT |
Guaranteed amount of memory for all requests in pool | INT4 |
INT4 |
| 340 | MSSRGPOOLID |
ID of a resource pool | INT4 |
INT4 |
| 341 | MSSRMINROUNDS |
Number of entries removed from memory pool | DEC | |
| 342 | MSSRNGROWS |
Est. number of rows from the table that fall within range | MSSROWCNT |
DEC |
| 343 | MSSROWCOUNT |
SQL Server count of rows returned | MSQBIGINT |
DEC |
| 344 | MSSROWLCKCNT |
Index op stats: Count of row locks requested | DEC | |
| 345 | MSSROWLCKWAITCNT |
Index op stats: Count of row lock waits | DEC | |
| 346 | MSSROWLCKWAITMS |
Index op stats: Row lock waits in ms | DEC | |
| 347 | MSSROWLOCKS |
Row locks allowed | CHAR | |
| 348 | MSSROWMAXLEN |
Maximum size of a row | INT2 | |
| 349 | MSSROWMINLEN |
Minimum size of a row | INT2 | |
| 350 | MSSROWMODCTR |
Row modification counter | INT4 | |
| 351 | MSSROWOVERFLOWFTCHINBYTES |
Index op stats: Data bytes from ROW_OVERFLOW_DATA | DEC | |
| 352 | MSSROWOVERFLOWFTCHINPAGES |
Index op stats: Data pages from ROW_OVERFLOW_DATA | DEC | |
| 353 | MSSRQMAXCPUSEC |
Maximum CPU use limit in seconds | INT4 |
INT4 |
| 354 | MSSRQMAXMEMPCT |
Maximum memory grant in percent | INT4 |
INT4 |
| 355 | MSSRQMEMTIMEOUT |
Memory grant timeout in seconds of a single request | INT4 |
INT4 |
| 356 | MSSRUNDATE |
MS SQL Server: Backup history information | CHAR8 |
CHAR |
| 357 | MSSRUNPRIO |
MS SQL Server task run priority | INT4 |
INT4 |
| 358 | MSSRUNTIME |
MS SQL Server backup history execution time | UZEIT |
TIMS |
| 359 | MSSRUNVALU |
run_value of sp_configure parameter | CHAR11 |
CHAR |
| 360 | MSSSAMPLEDT |
Sample date for table history | MSSDATE |
DATS |
| 361 | MSSSAMPLEDTDL |
Sample delta date in table history | MSSDATE |
DATS |
| 362 | MSSSAMPLETM |
Sample time for table size history | MSSTIME |
TIMS |
| 363 | MSSSAPRL |
SAP Release for SQL Server Monitor | CHAR | |
| 364 | MSSSAPUSER |
The user name in the SAP system. | CHAR | |
| 365 | MSSSATSUN |
Choose Saturday or Sunday | MSSSATORSUN |
INT1 |
| 366 | MSSSCANDENSITY |
Scan density | DEC | |
| 367 | MSSSCHDESC |
Sql Agent Job scheule Information | CHAR | |
| 368 | MSSSCHEMA |
Schema name | MSSSYSNAME |
CHAR |
| 369 | MSSSCHEMASZMB |
MSS schema size in MB | DEC | |
| 370 | MSSSCHPUBLISHED |
is_schema_published from sys.objects | FLAG |
CHAR |
| 371 | MSSSCLEN |
Length of column from syscolumns | INT2 |
INT2 |
| 372 | MSSSCNLL |
Nullable Flag | INT4 |
INT4 |
| 373 | MSSSCPRC |
Precision, the number of digits in a decimal number. | INT2 |
INT2 |
| 374 | MSSSCSCL |
The number of digits to the right of the decimal point | INT4 |
INT4 |
| 375 | MSSSEQ |
Deadlock sequence number | MSSINT4 |
INT4 |
| 376 | MSSSERVER1 |
MS SQL Server server to be used for a SQL task execution | TEXT30 |
CHAR |
| 377 | MSSSERVER_ |
MS SQL Server server to be used for a SQL task execution | TEXT30 |
CHAR |
| 378 | MSSSESCPUTIME |
CPU time for a SQL session (ms) | INT4 |
INT4 |
| 379 | MSSSESNUMLOGRDS |
number of reads performed by a session | MSQBIGINT |
DEC |
| 380 | MSSSESNUMREADS |
number of reads performed in a session | MSQBIGINT |
DEC |
| 381 | MSSSESNUMWRITES |
Number of writes performed in a session | MSQBIGINT |
DEC |
| 382 | MSSSESSINTFNAME |
MSS Session client interface name | CHAR64 |
CHAR |
| 383 | MSSSESSINTFVER |
MSS Session client interface name | INT4 | |
| 384 | MSSSESSIONID |
Session ID for SQL Server | MSSINT4 |
INT4 |
| 385 | MSSSEVERE |
MS SQL Server severity | INT4 |
INT4 |
| 386 | MSSSIGWTTIM |
Total signal wait time | DEC | |
| 387 | MSSSINGLETONLOOKUPCNT |
Index op stats: Count of single row retrievals | DEC | |
| 388 | MSSSNAPSHOT |
Database name | MSSSYSNAME |
CHAR |
| 389 | MSSSPHTEXT |
Output line of sp_helptext | MSSCSC255 |
CHAR |
| 390 | MSSSPID |
MS SQL Server process ID | INT2 |
INT2 |
| 391 | MSSSPIDTXT |
MS SQL Server process ID | CHAR20 |
CHAR |
| 392 | MSSSPNAME |
Stored procedure name | CHAR128 |
CHAR |
| 393 | MSSSPNUM |
MS SQL Server total number of stored procedured within DB | INT4 |
INT4 |
| 394 | MSSSPPARS |
MS SQL Server parameter list of a stored procedure call | TEXT8192 |
CHAR |
| 395 | MSSSPREVI |
MS SQL Server: Stored procedure revision | MSSSPREVI |
CHAR |
| 396 | MSSSPSIZE |
MS SQL Server total size of stored procedures (2K pages) | INT4 |
INT4 |
| 397 | MSSSPVER |
MS SQL Server build number | TEXT4 |
CHAR |
| 398 | MSSSQLBATCHES |
Number of SQL Batches (per second) | MSSCOLLSLOPE |
DEC |
| 399 | MSSSQLCACHEMEM |
SQL Server SQL cache memory | MSSCOLLMEMSIZE |
DEC |
| 400 | MSSSQLHANDLE |
handle pointing to sql statment or procedure | MSSHANDLE |
CHAR |
| 401 | MSSSQLTEXT |
SQL definition statement text | MSSCSSTR |
STRG |
| 402 | MSSSQLVER |
SQL Server Version | CHAR | |
| 403 | MSSSTADESC |
Sql Agent Job status description | CHAR | |
| 404 | MSSSTARTOFFSET |
Start statement offset | INT4 |
INT4 |
| 405 | MSSSTATSDATE |
Last update statistics | CHAR | |
| 406 | MSSSTATSSCHVER |
Statistics schema version | INT4 | |
| 407 | MSSSTATUS |
MS SQL-Server process status | TEXT10 |
CHAR |
| 408 | MSSSTMTHCALLS |
Number of SQL Statement executions during period | DEC | |
| 409 | MSSSTMTHCOLLID |
Unique ID of a set of collected expensive SQL Statements | DEC | |
| 410 | MSSSTMTHCPU |
Total CPU of all statements during the period | DEC | |
| 411 | MSSSTMTHDT |
Date when SQL Statement statistics were saved | DATS | |
| 412 | MSSSTMTHELPST |
Total elapsed time of all sql statements during the period | DEC | |
| 413 | MSSSTMTHLOGRD |
Logical reads during the period | DEC | |
| 414 | MSSSTMTHLOGWRT |
Logical writes during the period | DEC | |
| 415 | MSSSTMTHPHYSRD |
Physical reads during period | DEC | |
| 416 | MSSSTMTHSECSINCE |
Number of seconds since prior measurement | INT4 |
INT4 |
| 417 | MSSSTMTHTM |
Time when SQL Statement statistics were saved | TIMS | |
| 418 | MSSSUBSYST |
MS SQL Server subsystem used for a SQL task | TEXT30 |
CHAR |
| 419 | MSSSUBVER |
MS SQL Server sub version number | TEXT2 |
CHAR |
| 420 | MSSSWTPERREQ |
Signal wait time per request | DEC | |
| 421 | MSSSYNCTRANSUB |
Sync tran subscribed | FLAG |
CHAR |
| 422 | MSSSYSLOOKUPS |
Index usage: Number of lookups by system queries | DEC | |
| 423 | MSSSYSNAME |
SQL Server DB Object Name | CHAR | |
| 424 | MSSSYSSCANS |
Index usage: Number of scans by system queries | DEC | |
| 425 | MSSSYSSEEKS |
Index usage: Number of seeks by system queries | DEC | |
| 426 | MSSSYSUPDATES |
Index usage: Number of updates by system queries | DEC | |
| 427 | MSSSZCHKDURATE |
Execution duration of table size checks | INT4 |
INT4 |
| 428 | MSSTABASRTKEY |
Sort key for stored procs in MSS_RAT_TABANALYZE | CHAR | |
| 429 | MSSTABASRTSTR |
Sort description used in MSS_RAT_TABANALYZE | CHAR | |
| 430 | MSSTABBUFF |
SAP table buffering status on application server. | CHAR4 |
CHAR |
| 431 | MSSTABID |
MS SQL Server table object id | INT4 |
INT4 |
| 432 | MSSTABLE |
Table name | MSSSYSNAME |
CHAR |
| 433 | MSSTABNUM |
MS SQL Server number of tables within the database | INT4 |
INT4 |
| 434 | MSSTABOPTS |
Table options on locking and memory | CHAR10 |
CHAR |
| 435 | MSSTABSIZE |
MS SQL Server total size of all tables within DB (in 2k pgs) | INT4 |
INT4 |
| 436 | MSSTASKCMD |
MS SQL Server task command | TEXT255 |
CHAR |
| 437 | MSSTASKID |
MS SQL Server task identifier | INT4 |
INT4 |
| 438 | MSSTATE |
Server Status | MSSTATE |
RAW |
| 439 | MSSTATESTR |
Status of the AS Instance | CHAR10 |
CHAR |
| 440 | MSSTBRESVD |
MS SQL Server reserved pages for table | INT4 |
INT4 |
| 441 | MSSTBUSED |
MS SQL Server number of used pages of a table | INT4 |
INT4 |
| 442 | MSSTCODE |
Transaction code | TCODE |
CHAR |
| 443 | MSSTIMESTAMP |
time stamp from SQL Server | TIMESTAMP |
REF |
| 444 | MSSTKMSGID |
MS SQL Server task handler return message ID | INT4 |
INT4 |
| 445 | MSSTNAME |
Table name | AS4TAB |
CHAR |
| 446 | MSSTOTALBUFPGS |
Total number of pages (buffer manager) | MSSCOLLMEMSIZE |
DEC |
| 447 | MSSTOTIDXP |
MS SQL Server number of index pages for all idx of one table | INT4 |
INT4 |
| 448 | MSSTOTINSZ |
MS SQL Server total index size within the database (#2K pgs) | INT4 |
INT4 |
| 449 | MSSTOTLCONS |
Number of total connections to SQL Server | INT4 | |
| 450 | MSSTOTLLCOUNT |
Total lock or latch wait events | DEC | |
| 451 | MSSTOTLLTIME |
Total lock/latch wait time | DEC | |
| 452 | MSSTOTSCHEMASZMB |
MSS schema size in MB | DEC | |
| 453 | MSSTOTSTMP |
MS SQL Server timestamp of the end of a selected time period | CHAR14 |
CHAR |
| 454 | MSSTRACEDIR |
MSSQL : SQL trace directory | CHAR | |
| 455 | MSSTRACEFN |
MSSQL : SQL trace filename | CHAR | |
| 456 | MSSTRANSACTIONID |
Transaction identifier request executes under | MSQBIGINT |
DEC |
| 457 | MSSTRANSACTIONS |
Transactions per second | MSSCOLLSLOPE |
DEC |
| 458 | MSSTRIGGER |
Trigger name | MSSSYSNAME |
CHAR |
| 459 | MSSTRXISOLEVEL |
MSS Transaction Isolation level | CHAR | |
| 460 | MSSTSKDURA |
MS SQL Server task run duration | INT4 |
INT4 |
| 461 | MSSTSKNAME |
MS SQL Server task name | CHAR | |
| 462 | MSSTSKRDAT |
MS SQL Server task run date | INT4 |
INT4 |
| 463 | MSSTSKRTIM |
MS SQL Server task runtime | INT4 |
INT4 |
| 464 | MSSTSKSTAT |
MS SQL Server task run status | INT4 |
INT4 |
| 465 | MSSTSQLVER |
MSSQL Multiconnect : Version of SAP TSQL layer | CHAR | |
| 466 | MSSTSTMP |
Timestamp for deadlock tracking | MSSTSTMP |
CHAR |
| 467 | MSSTTLCLRTIME |
Total amount of CLR time consumed by executions of this plan | DEC | |
| 468 | MSSTTLELAPSEDTIME |
Total elapsed time in microseconds | DEC | |
| 469 | MSSTTLLOGICALREADS |
Total logical reads for this plan since compiled | DEC | |
| 470 | MSSTTLLOGWRITES |
Total logical writes for this plan since compiled | DEC | |
| 471 | MSSTTLPHYSREADS |
Total physical reads for this plan | DEC | |
| 472 | MSSTTLPHYSWRITES |
Total physical writes for this plan since compiled | DEC | |
| 473 | MSSTTLROWS |
Total number of rows returned for a query plan | DEC | |
| 474 | MSSTTLWORKERTIME |
Total amount of CPU time consumed by executions of this plan | DEC | |
| 475 | MSSTUNIT |
MSSQL DBCOLL : Time grid unit | MSSTUNIT |
CHAR |
| 476 | MSSTXACT |
Transaction name | CHAR | |
| 477 | MSSULOOKUPS |
Index usage: Number of lookups by user queries | DEC | |
| 478 | MSSUNAME |
MS SQL Server user name | TEXT30 |
CHAR |
| 479 | MSSUNUSEDSIZE |
Unused size in KB | DEC | |
| 480 | MSSUQCOMPILES |
Number of compilations and recompilations | DEC | |
| 481 | MSSUSCANS |
Index usage - Number of scans by user queries. | DEC | |
| 482 | MSSUSDIMTX |
MS SQL Server number of used image or text pages for table | INT4 |
INT4 |
| 483 | MSSUSEDSIZE |
Used size in KB | DEC | |
| 484 | MSSUSEEKS |
Index usage - Number of seeks by user queries. | DEC | |
| 485 | MSSUTOTALOPS |
Index usage: Total user operations on the index | DEC | |
| 486 | MSSUTOTOPS |
Number of seeks and scans by user queries. | DEC | |
| 487 | MSSUUPDATES |
Index usage: Number of updates by user queries | DEC | |
| 488 | MSSVERSION |
MS SQL Server version | TEXT50 |
CHAR |
| 489 | MSSVGHOSTCNT |
Version ghost record count | DEC | |
| 490 | MSSVIEW |
View name | MSSSYSNAME |
CHAR |
| 491 | MSSVIEWORTABLE |
View or table name | MSSSYSNAME |
CHAR |
| 492 | MSSVOLNAME |
MS SQL Server volume name | TEXT6 |
CHAR |
| 493 | MSSWAITCAT |
Wait category | MSSSYSNAME |
CHAR |
| 494 | MSSWAITERIND |
Waiter index name | CHAR | |
| 495 | MSSWAITERMODE |
Waiter mode | CHAR | |
| 496 | MSSWAITEROBJ |
Waiter object name | CHAR | |
| 497 | MSSWAITFACTOR |
Elapsed time/CPU time | DEC | |
| 498 | MSSWAITHWTRATIO |
Wait ratio during data collection period | DEC | |
| 499 | MSSWAITRSC |
Wait Resource as seen in sysprocesses | CHAR | |
| 500 | MSSWAITSEC |
Current wait time of the process in seconds | INT4 |
