we want to monitor certain SQL 2014 database (MDF+LDF) when it reach certain size for example 150 GB , to alert when it reach this size. is there any possible way to do this?
checked the SCOM monitors they are more for the space left.
4 Likes
There’s an article by Kevin Holman on creating a database size performance counter here. Once that’s in place it should be simple to add an alert which alerts when it reaches a certain size.
1 Like