Monitor databases size
Is it possible to add in the SQL Server Instance part of the Monitoring the ability to define threshold for database sizes?
For example, what I need is to define that if the size of the BizTalkDTADb is greater than a threshold, I need to be alerted.
Thank you for your valuable feedback, as you are aware this is currently not possible. However, you can utilize our Database Query Monitoring where you can execute the following SQL Query to monitor your DB Size:
SELECT total_size_mb = CAST(SUM(size) * 8. / 1024 AS INT)
FROM sys.master_files WITH(NOWAIT)
WHERE database_id = DB_ID()
BizTalk360 Feedback Team