The IN_DB_UTIL_SP_GET_RPM stored procedure will calculate the Rows Per Minute (RPM) when providing the number of affected rows along with the total duration in milliseconds. This can be used to quantify the throughput of an operation when measuring the duration and number of rows affected.
| Parameter | Description | |
|---|---|---|
| ROWS | Type: | INPUT |
| Datatype: | INTEGER | |
| Default Value: | NULL | |
| Description | Number of rows to use for calculating the RPM. | |
| MSEC | Type: | INPUT |
| Datatype: | BIGINT | |
| Default Value: | NULL | |
| Description | Number of milliseconds to use for calculating the RPM. | |
| RPM | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | NULL | |
| Description | The calculated rows per minute based on the provided number of rows and milliseconds. | |
Example
DECLARE @V_TOTAL_ROWS INTEGER = 50000, @V_TOTAL_MSEC BIGINT = 60000, @V_ROWS_PER_MINUTE INTEGER; EXEC IN_GET_RPM @V_TOTAL_ROWS, @V_TOTAL_MSEC, @RPM = @V_ROWS_PER_MINUTE OUTPUT; PRINT 'Rows Per Minute = '+CONVERT(VARCHAR,@V_ROWS_PER_MINUTE);