Return
-
Title
Description of monthly database transaction rates (per minute) -
Description
What is the concept of SQL Server Transaction Monthly Summary?This report shows monthly average and maximum transaction rates for each database on a selected SQL Server Instance.How to clarify Average Tran Rate and Max Tran Rate of this report ? -
Resolution
‘Avg Tran Rate’ and ‘Max Tran Rate’ are the average and maximum value during the time span.They are grouped by each month and each Database to show the Database’s average transaction rate and maximum transaction rate per minute in the month.The query parameters ‘Start Date’ and ‘End Date’ are used to retrieve the underlying data. SSR collect these data once every two hours.‘Avg Tran Rate’ and ‘Max Tran Rate’ are an approximate values, they are generally reflecting the transaction rate of the database.This data of this report is collected from Database Info collection. Select Configure | Scheduling option from top toolbar and select the connection name in mind. Scroll down list of collection to "Database Info". Edit this collection to ensure the Collect for Report option is enabled.