Monitor databases size
Hi,
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.
This feature request has been completed. It is available in the latest release of BizTalk360 9.0.3 version (https://docs.biztalk360.com/docs/v9031442001)
-
Hello,
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()Thank you,
BizTalk360 Feedback Team