SQL Monitor becomes unlicensed without warning
Published 21 October 2021
SQL Monitor may become unlicensed without warning if a serial number is removed from the Licensing page. This may happen if you have more than one version of SQL Monitor installed on your network, and each version is using the same Data Repository database.
To view the details of the Data Repository database, either:
- Check the name and location of the Data Repository database: go to Configuration > About and select About. The Database entry under Base Monitor is the Data Repository database.
Or:
- Run the query
sys.sp_who2
against the database, and find processes that display SQL Monitor - Repository in the ProgramName column. The HostName column entries for these rows confirm which machines are running SQL Monitor.
You must store collected data in a separate Data Repository database for each installation. If you are only using one version of SQL Monitor, simply uninstall the redundant version(s).
If you want to maintain separate versions of SQL Monitor, create a new Data Repository database for one of the installations, and update the connection string between the Base Monitor service and the database. For details of how to do this, see Moving the SQL Monitor database.