Licensing dashboard
Top panel includes information about the exact number of licenses required. Bottom panels shows the calculations on which the top panel values are based on:
License optimization
Performance Store is ideal for determining the performance impact of different databases. Based on the resource usage, databases can be moved around and consolidated on fewer servers, hence reducing license costs.
License requirements are also based on the SQL Server configuration. Performance Store will show, what configuration options requires the SQL Server to be licensed. These configuration options can be seen in the following columns:
| Column | Explanation |
| require_license_due_to_not_clean | If a secondary non-readable replica contains databases that are not a part of an Availability Group, the SQL Server must be licensed |
| require_license_due_to_mixed | A SQL Server contains multiple Availability Groups with secondary non-readable replicas, but also contains at least one primary replica |
| require_license_due_to_ags_with_readable_secondary | If a secondary replica is readable, the SQL Server must be licensed |
| require_license_due_to_ags_with_secondary_backup | If backups are taken on a secondary replica, the SQL Server must be licensed. Note, this is only applicable if the chosen Licensing model is not “Software Assurance” |
| require_license_due_to_prod_in_dev | If a non-Developer Edition SQL Server (e.g. Enterprise Edition or Standard Edition) is used on a non-production SQL Server, the SQL Server must be licensed |
| require_license_due_to_more_than_one_high_availability_replica | High Availability replica is defined as a passive replica setup as synchronous replica with automated failover. If an Availability Group has more than one High Availability replica, the High Availability replica must be licensed |
| require_license_due_to_more_than_one_disaster_recovery_replica | Disaster Recovery replica is defined as a passive replica setup as asynchronous replica with manual failover. If an Availability Group has more than one Disaster Recovery replica, the Disaster Recovery replica must be licensed |
In the Performance Store Control Center, it can be chosen if Software Assurance is used or not:
SQL Server license costs are calculated differently whether Software Assurance is used or not.
For more information see: Licensing
Corresponding views in the Performance Store database:
dbo.v_license_info
dbo.v_license_info_detailed