2.10.2 Notes on monitoring Microsoft SQL Server
- Organization of this subsection
(1) Notes on monitoring all versions of Microsoft SQL Server
-
Due to the specifications of Microsoft SQL Server, the amount of database space used is not updated unless a specified number of transactions are performed. If the amount changes dramatically after only a few transactions, it is possible that correct values cannot be collected in the following fields. In this case, execute the DBCC UPDATEUSAGE command for the target database to display correct values. For details about how to execute the DBCC UPDATEUSAGE command and other details, see the Microsoft SQL Server documentation. The value of Free % field or Data Unallocate % field in the PD_DS record might be negative. In this case, Specify the value of DB_FREE_PERC_NUMBER to replace the value of Free % field. #1 This replacement is enabled only when the value of DB_FREE_PERC_OPTION is Y. #2
- #1
-
If you set the noticeable value to the DB_FREE_PERC_NUMBER, you can easily judge that the actual value of Free % is negative.
- #2
-
If the value of Free % field is replaced when its value is negative, "KAVF21847-I" message is output to the agent log. If the value of Data Unallocate % field is replaced when its value is negative, "KAVF21851-I" message is output to the agent log.
Record ID
View name (Manager name)
PI_DI
Data Growth % (DATA_GROWTH)
PI_DI
Index Growth % (IDX_GROWTH)
PD_DS
Data Mbytes (DATA)
PD_DS
Data Space Mbytes (DATA_SPACE_MB)
PD_DS
Data Unallocate Mbytes (DATA_UNALLOCATE_MB)
PD_DS
Data Unallocate % (DATA_UNALLOCATE_RATIO)
PD_DS
Free % (PERC_FREE)
PD_DS
Free Mbytes (FREE_SPACE)
PD_DS
Index Mbytes (IDX)
PD_DS
Rsvd Mbytes (RESERVED)
PD_DS
Unused % (PERC_USED)
PD_DS
Unused Mbytes (UNUSED)
PD_SS
Data Mbytes (DATA)
PD_SS
Free % (PERC_FREE)
PD_SS
Free Mbytes (FREE_SPACE)
PD_SS
Index Mbytes (IDX)
PD_SS
Rsvd Mbytes (RESERVED)
PD_SS
Unused % (PERC_USED)
PD_SS
Unused Mbytes (UNUSED)
PI_SI
Data Mbytes (DATA)
PI_SI
Free % (PERC_FREE)
PI_SI
Free Mbytes (FREE_SPACE)
PI_SI
Index Mbytes (IDX)
PI_SI
Rsvd Mbytes (RESERVED)
PI_SI
Unused % (PERC_USED)
PI_SI
Unused Mbytes (UNUSED)
-
The term "process" used in the descriptions of records and fields is different from the term "process" used as an operational unit of Windows application programs.
(2) Notes on monitoring of Microsoft SQL Server 2019 or later versions
Environments with the "secondary to primary replica read/write connection redirection for Always On Availability Groups" features introduced by the Microsoft SQL Server 2019 are not supported.