The following table shows how to calculate the number of instances for each record collected by RM for Microsoft SQL server.
Use sqlcmd or a similar program to access the Microsoft SQL Server to be monitored, and execute an SQL statement to obtain the number of instances. If a calculation method for the target record is provided in the table, use that method.
Table A-1 Calculating the number of instances for records
Record | SQL statements that obtains the number of instances, and calculation method |
---|---|
PI | The number of instances is 1. |
PI_PI2 | The number of instances is 1. |
PI_SERV | The number of instances is 1. |
PI_SRV2 | The number of instances is 1. |
PI_SI | The number of instances is 1. |
PD | The number of instances is 1. |
PD_CD | Number of the environment setting options shown in the result set when you execute the sp_configure system stored procedure. |
PD_DD | SELECT count(*) FROM master..sysdatabases |
PD_DS | SELECT count(*) FROM master..sysdatabases |
PD_IA | The number of instances is 1. |
PD_LD | SELECT count(*) FROM master..syslockinfo |
PD_LOCK | The number of instances is 1. |
PD_PDET | SELECT count(*) FROM ( master..sysprocesses a LEFT JOIN master..syslogins b ON a.sid = b.sid ) LEFT JOIN master..sysusers c ON a.sid = c.sid |
PD_SS | The number of instances is 1. |