d365fo_get_database_statistics
Retrieve comprehensive database statistics for Dynamics 365 Finance & Operations, including table sizes, record counts, version information, and performance metrics to assess database health and optimize performance.
Instructions
Get comprehensive database statistics and analytics including:
Overall database size and table counts
Record counts by table
Global version statistics
Environment statistics
Cache hit rates and performance metrics
Storage utilization analysis
Data distribution insights
Use this tool to understand the overall state and health of the metadata database.
Args: include_table_stats: Include per-table statistics (row counts, sizes). include_version_stats: Include global version and environment statistics. include_performance_stats: Include cache performance and query statistics. profile: Configuration profile to use (optional - uses default profile if not specified)
Returns: Dictionary with database statistics
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| profile | No | default | |
| include_table_stats | No | ||
| include_version_stats | No | ||
| include_performance_stats | No |