- 12 Dec 2019
- 2 Minutes to read
- Print
- DarkLight
- PDF
Database Size
- Updated on 12 Dec 2019
- 2 Minutes to read
- Print
- DarkLight
- PDF
For a healthy BizTalk environment, it is important to keep an eye on database growth. Some of the BizTalk databases can grow extremely big; it’s not uncommon to have over 1 million records in certain tables (ex: MessageInOutEvents table in Tracking Database). Potentially, there can be a high performance impact when the database grows and queries become slower with more data in the database which, in turn, affects your BizTalk operations.
With the Database size monitoring feature, users can monitor the database and log file size of BizTalk and BizTalk360 databases, by simply configuring the error and warning threshold values for the database and log file sizes. For example, if the size of the BizTalkDTADb is greater than a threshold value configured, then you will get notified.
BizTalk360 will automatically list all the below BizTalk and BizTalk360 databases for the specific environment. These databases are:
- BizTalkDTADb
- BizTalkMgmtDb
- BizTalkMsgBoxDb
- BizTalkRuleEngineDb
- BAM Databases
- SSODB
- BizTalk360
Setting up Database Size Monitoring
You can follow the below steps to configure database size monitoring:
- Log in to BizTalk360 application
- Click the Monitoring tab in the navigation bar
- Click the Expand button in the Manage Mapping section
- Select the Alarm name (Creating an alarm) from the drop-down, which you would like to associate the for monitoring
- Click BizTalk Environments => Database Size. Here all the BizTalk and BizTalk360 databases, which are available in the environment, are listed. Along with the total reserved data file and log file size of the databases
To monitor the size of a particular database, click the Config icon at the most right column of the grid, which opens the configuration blade where you can define the threshold rules for monitoring.
Once the threshold rules are configured and saved, the status of the database size will be displayed in the grid. If any threshold violation happens, the user will be notified through the configured notification channel(s).
Below are the database parameters you can monitor:
Parameter | Explanation |
---|---|
Data File Size | Total reserved data file size of the database |
Data File Used Space | Total used space of the data file |
Data File Available Space | Total available data file size |
Log File Size | Total reserved Log file size of the database |
Log File Used Space | Total used space of the log file |
Log File Available Space | Total available log file size |