Use SQL Monitor in read only mode
mykaska
Posts: 19 Bronze 2
Hi,
Is any way I can restore a copy of working SQL Monitor database
and use my own instance of SQL Monitor in Read Only mode (no metrics collected, only showing what is in the restored database)?
Is any way I can restore a copy of working SQL Monitor database
and use my own instance of SQL Monitor in Read Only mode (no metrics collected, only showing what is in the restored database)?
Tagged:
Answers
There isn't a read-only mode that works in that way (you can't make configuration changes rather than it not collecting data). You could restore a backup to a separate SQL Monitor install and just keep everything suspended (it would be unlicensed anyway unless you wanted to use double the amount of licenses) at which point you could look back at the historical data that way.
There was an issue before version 12.1.19 that didn't let you view the server overview for suspended entities, but that has been fixed, so you can see the overview info there as well as the metrics on the Analysis page. Also you would probably want to set the retention period to forever so it didn't purge the old data (unless you planned on restoring newer backups when the old data was purged).
Kind regards,
Alex
Have you visited our Help Center?