SCOM SQL 2017+ DB Log Free Space in Megabyte
In the SQL 2017+ Management Pack is a Monitor to monitor the free DB log space in percent. We would like to monitor the free DB log space additionally in MB. We need this because we have very much DBs, and they are from very small to very big. Its to much effort to set for every DB another percent treshold. And if we set a threshold 10%, this is good for small DBs, but if we have a big DB, there is no problem when free space is for example 10% but still 100GB. So we wanna set a threshold in percent to generate a warning. And we wanna set a critical treshold in MB, so we can generate an alarm, if there is really a low DB log space.