Comments
Sort by recent activity
Hi, there are no current plans to support GCP for hosting the SQL Monitor repository. However, this just sounds like the exact same problem that using Azure SQL DBs has (ie can't access the model database). So you might be able to workaround this in the same way we recommend for Azure, by creating a blank empty database in GCP, and when you install Monitor, use an existing database. The installer can then connect to it, and perform a schema upgrade and away you go. I haven't tested GCP and I do want to stress it isn't Supported, but there's no reason I can think of why it wouldn't just work the same. / comments
Hi, there are no current plans to support GCP for hosting the SQL Monitor repository.However, this just sounds like the exact same problem that using Azure SQL DBs has (ie can't access the model da...
This custom metric might help https://sqlmonitormetrics.red-gate.com/percentage-of-free-log-space/ if you mean an alert for log size. You can then setup an alert email for that custom metric. / comments
This custom metric might help https://sqlmonitormetrics.red-gate.com/percentage-of-free-log-space/ if you mean an alert for log size. You can then setup an alert email for that custom metric.
Sorry, I'm afraid we dont have a method or tool to help make this work. / comments
Sorry, I'm afraid we dont have a method or tool to help make this work.
I suspect this was the case - sorry that I can't be of more help right no, but please do post over on the sql monitor uservoice: https://sqlmonitor.uservoice.com/forums/91743-suggestions with as much background info/use case you can provide. / comments
I suspect this was the case - sorry that I can't be of more help right no, but please do post over on the sql monitor uservoice: https://sqlmonitor.uservoice.com/forums/91743-suggestions with as mu...
There's no disk utilisation alert for host machines I'm afraid, but the average read/write alerts might be sufficient for you? Or there's an average i/o stalls custom metric here: https://sqlmonitormetrics.red-gate.com/average-io-stalls/, which you could then create an alert for. / comments
There's no disk utilisation alert for host machines I'm afraid, but the average read/write alerts might be sufficient for you? Or there's an average i/o stalls custom metric here: https://sqlmonito...
The mentioned attribute is the easiest way to detect that it was obfuscated by SA. I think that there will be always some footprint that can track down which obfuscator was used. That's because each obfuscator uses different techniques to obfuscate assembly and because of this, if you analyse the output, the application would be obfuscated in a way that is specific to obfuscator. As you said, some obfuscation methods are irreversible like obfuscating the names. There are also some obfuscation that will be always reversible and we can only make them harder to reverse like obfuscation of strings in the application (we can make it hard to analyse but in the end the application will have to resolve them in run-time, so if the application can get them then any de-obfuscator can simulate what an application will do in run-time and get this string also). If you are worried then, unfortunately, there is always the possibility of reversing some forms of obfuscation and for .NET applications, for someone that knows what they are doing it is not that hard to analyse even the obfuscated assembly. / comments
The mentioned attribute is the easiest way to detect that it was obfuscated by SA. I think that there will be always some footprint that can track down which obfuscator was used. That's because eac...
No I don't think so. I'll forward this on to the .net team now. / comments
No I don't think so. I'll forward this on to the .net team now.
With some basic analysis, it looks like we have some instrumentation specific for MySQL. I've not actually got the ability to test with MariaDB so really I'd just give it a go using normal sql profiling: https://documentation.red-gate.com/app/setting-up-and-running-a-profiling-session/profiling-sql-queries. I would expect the calls to show up here as they would with sql/oracle. / comments
With some basic analysis, it looks like we have some instrumentation specific for MySQL. I've not actually got the ability to test with MariaDB so really I'd just give it a go using normal sql prof...
Thanks for the feedback! 1 - this actually does not work at all yet I'm afraid to say, but we will correct the documentation to reflect what should work (and will work when we've fixed it). 2 - this does not appear empty for me with 11.0.5 at least, can you retest with the latest version? 3 - I've raised an issue for this. Not sure if it should be mandatory or the documentation needs changing - we'll get to it. We are working on a better way of making the MSIs available, no ETA on that yet though! / comments
Thanks for the feedback!1 - this actually does not work at all yet I'm afraid to say, but we will correct the documentation to reflect what should work (and will work when we've fixed it).2 - this ...
Hi Graham, in theory, it doesn't matter where any of the individual components are installed, as long as they are on Windows Servers, and if they can talk to each other. Take a look at the documentation here: https://documentation.red-gate.com/sm/installation-and-setup/planning-the-sql-monitor-infrastructure-and-installation which will give background information, as well as ports required. You need to take into consideration the network connectivity between the machines - in practice there is no reason why a web server on Azure wouldn't work but I've never seen it done with Monitor so I can't really say how it would perform. Your next, important, consideration is the monitoring service accounts - if they're running in Azure they also need to be able to properly authenticate to the machines you're monitoring. / comments
Hi Graham, in theory, it doesn't matter where any of the individual components are installed, as long as they are on Windows Servers, and if they can talk to each other. Take a look at the document...