| FILEGRPNA |
Filegroup name |
CHAR |
128 |
0 |
|
MSSFG
|
|
| LOGFILENA |
Logical file name |
CHAR |
128 |
0 |
|
MSSFILE
|
|
| PHYFILENA |
Physical file name (full path) of the database file. |
CHAR |
520 |
0 |
|
MSQPHYFLNA
|
|
| FILEID |
FILE ID of DB file for SQL Server |
INT4 |
10 |
0 |
|
MSSFILEID
|
|
| FLSIZEMB |
File size in MB. |
DEC |
15 |
0 |
|
MSQFLTSIZE
|
|
| ALLOCMB |
Allocated space in a DB file in MB |
DEC |
15 |
0 |
|
MSSALLOCFILEMB
|
|
| FREEPCT |
Free percentage of space in a SQL Server file |
DEC |
6 |
2 |
|
MSSFREEPCT
|
|
| GROWTH |
File growth step configured in SQL Server. |
CHAR |
10 |
0 |
|
MSSDBGROW
|
|
| GROWTHMB |
True file growth in MB |
DEC |
16 |
0 |
|
MSQFLTGROW
|
|
| FLMAXSIZE |
File size limit in MB configured in SQL Server. |
CHAR |
10 |
0 |
|
MSSMAXSIZE
|
|
| PRIMARYFILE |
Primary file containing startup information and also data |
CHAR |
1 |
0 |
|
MSQFLPRIM
|
|
| READONLY |
The file group is read only |
CHAR |
1 |
0 |
|
MSQFLGRPRO
|
|
| LOGDEV |
file is a log file |
CHAR |
1 |
0 |
|
MSQFLLGDEV
|
|
| GRWTHPCT |
SQL Server file has growth represented in percentage |
CHAR |
1 |
0 |
|
MSQFLGRPCT
|
|
| DEVFREEMB |
Free space left on file system (partition) in MB. |
DEC |
15 |
0 |
|
MSQDEVFREE
|
|
| ALERTSTATUS |
ALERT Status , 'R','Y','G' - red,yellow,green |
CHAR |
1 |
0 |
|
MSSALERTSTATUS
|
|
| FILEMSG |
MSS Alert Text as seen in RZ20 |
CHAR |
50 |
0 |
|
MSSALERTTXT
|
|