SQL Monitor 9

SQL Monitor becomes unlicensed without warning

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.

 


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?