Activity overview
Latest activity by judy_palmer
When we moved to IIS so that we could use HTTPS I disabled the Redgate monitor web service. Seems that this needs to be running to update the estate. I worked that out because it is running on our Azure Redgate server and that didn't have the same problem. / comments
When we moved to IIS so that we could use HTTPS I disabled the Redgate monitor web service. Seems that this needs to be running to update the estate. I worked that out because it is running on our ...
ATurner said:
Hi judy_palmer Can the server hosting the base monitor reach https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json ? This is where SQL monitor pulls the information from. Can see in there that SQL 2019 CU13 is indeed in there. The update normally occurs after 6 hours, after waiting this period did it not change? If so could you try restarting the " SQL Monitor Base Monitor" service? Could you also confirm which version it is you are running?
hi Andy sorry for the late reply I have been off sick for some time. Yes the server can access that so I don't know what's going on. We are currently running quite an old version 9.2.4.24230 but are planning (when I can find time) to upgrade to the latest version. How often should it update? It is currently showing the last update date when I manually downloaded the file. When should I expect it to have updated again? I'd like to know this before I restart the base monitor service. / comments
ATurner said:
Hi judy_palmerCan the server hosting the base monitor reach https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json ? This is where SQL monitor pulls t...
I have updated the jso as per these instructions: Versions data The versions data used by this page is obtained from the Redgate website and automatically updated each day. We aim to keep this up to date with the latest releases of SQL Server (for all versions that SQL Monitor supports). If SQL Monitor cannot download updates to this data automatically, it can be performed manually. To do this, download the latest version of the data from https://www.red-gate.com/products/dba/sql-monitor/assets/sql-server-versions.json and save it to a file at C:\ProgramData\Red Gate\SQL Monitor\SqlServerVersions.json. SQL Monitor will then pick up the updated data from this file within 6 hours. https://documentation.red-gate.com/sm9/estate/versioning-and-patching SQL monitor has not updated yet. What would stop the monitor from receiving the file automatically? It hadn't been updated for several months… / comments
I have updated the jso as per these instructions:Versions dataThe versions data used by this page is obtained from the Redgate website and automatically updated each day. We aim to keep this up to ...