SQL Monitor 12


Acquire your license by following the instructions from Managing your Redgate licenses.

Go to the Licensing page by doing the following:

  • Go to the Configuration tab and, under Licensing, select Licensing:

There are two ways to allocate licenses to the SQL Monitor installation - by logging with your RedGate Id to red-gate.com or by activating a serial number.

Allocate your licenses on red-gate.com

Click on Allocate your licenses on red-gate.com - you will be prompted to log in with an email address and password. If you don't have a RedGate ID follow the instructions in Creating and managing your Redgate ID.

You will be able to see all SQL Monitor licenses available to your ID and add or remove any of them from your SQL Monitor installation. 

When you go back to the Licensing page and refresh you will be able to see the updated number of licenses available to assign to your servers.

90 days before your license(s) expire, the purchaser will receive an renewal reminder. To ensure an un-interrupted monitoring service, you need to ensure licenses are renewed before expiry. If a license expires, it will become unavailable in SQL Monitor.

Note that if your SQL Monitor webserver is unable to contact permits.red-gate.com you will need to activate your licenses via a different mechanism - to do that follow the instructions in Offline activation.

Activate a perpetual license

Alternatively, you can activate a license via a serial number. This option works only for perpetual licenses. To do so Follow the Activate a perpetual license link, enter a license serial number in the field and click Activate

Allocating licenses

SQL Monitor detects the number of servers currently being monitored and allocates available licenses to them automatically. These are displayed in the Licensed servers list. If, during your evaluation, you were monitoring more servers than you purchased licenses for, or you subsequently add more servers to monitor than you have licenses available, the servers added most recently will not be allocated licenses. These are displayed in the Unlicensed servers list. Unlicensed servers are not removed from the Monitored Servers list, but they will not be monitored and alerts cannot be raised on them.

You can change which servers have licenses allocated to them using the < License and Unlicense > buttons to move selected servers from one list to the other.

In the example below, 5 licenses have been purchased and and a single license has been allocated to the single server currently being monitored. There are 4 spare licenses available.

Deactivating a license

You may need to deactivate a license if:

  • You are moving the Base Monitor service to a different machine.
  • You are evaluating a new version of SQL Monitor, and your existing license is for fewer servers that you want to monitor in trial mode; deactivating the license in this case will return you to trial mode (assuming you are within the evaluation period).
  • Red Gate sales or support have provided a different license to use.

To deactivate a license on red-gate.com

Follow the Allocate your licenses on red-gate.com link and log in. You will be able to see all SQL Monitor licenses available to your ID and add or remove any of them from your SQL Monitor installation. 

To deactivate a serial number

Select the serial number in the list and click Deactivate.

SQL Monitor contacts the Redgate licensing server, and the serial number is removed from the list.

If there is a problem deactivating, a message is displayed explaining the nature of the problem. You may need to contact Red Gate for further assistance.

What happens when I deactivate a license?

The relevant number of servers are automatically moved from Licensed servers to Unlicensed servers. For example, if your serial number was for 10 licenses, then 10 servers will be unlicensed.

If you have licensed your servers using several serial numbers, you may have more licensed servers than are being removed. In this case, SQL Monitor removes the oldest servers first (those that were added to SQL Monitor first).

If all your servers are now unlicensed, SQL Monitor displays a warning banner:

No further monitoring data will be collected, and no new alerts will be raised until you enter a serial number.

Didn't find what you were looking for?