How can we improve BizTalk360 Operations & Administration capabilities?

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.

13 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

David Grospelier shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • AdminBizTalk360 Feedback Team (Founder, BizTalk360) commented  ·   ·  Flag as inappropriate

    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

Feedback and Knowledge Base