Activity overview
Latest activity by alexiaamber
As far as I know, you can automate a lot of the configuration with PowerShell and the SQL Monitor API, but the custom metric itself still needs to be something SQL Monitor supports collecting. For your example, another approach is to create a custom metric that runs a query like SELECT COUNT(*) against each error table, then use the API/PowerShell to deploy the same metric and alert configuration across all of your monitored servers or databases instead of creating 100 alerts manually. I've done similar bulk configuration through the API, and it saved a lot of repetitive work. If all of your wheelie life tables follow the same pattern, scripting the creation of the metrics and alert settings is definitely the way I'd go rather than configuring each one individually. / comments
As far as I know, you can automate a lot of the configuration with PowerShell and the SQL Monitor API, but the custom metric itself still needs to be something SQL Monitor supports collecting. For ...
It seems like you're on the right track looking for the usage log in the Redgate.Monitor.WebService.logging.jsonc file. If the Website_Usage.XXXXXXXX.log file is not included in the .zip , it might be generated dynamically or stored elsewhere. You could check the configuration settings for the logging paths or reach out to Redgate support for further 1000games assistance. Good luck with your cleanup! / comments
It seems like you're on the right track looking for the usage log in the Redgate.Monitor.WebService.logging.jsonc file. If the Website_Usage.XXXXXXXX.log file is not included in the .zip, it might ...