Database Dashboard
The Environment - Databases pages have been renamed and moved to the new Dashboard section of WISdom
The Database Dashboard provides comprehensive visibility into your SQL Server databases across your infrastructure. This dashboard helps you monitor database health, track space utilization, analyze transaction patterns, understand cost allocation, and ensure your databases meet operational and compliance standards.
What You'll Find Here
The Database Dashboard gives you two complementary views of your databases:
Overview Tab - A multi-database view that shows aggregated metrics and trends across your entire environment or a filtered subset of databases. Use this view to identify patterns, compare configurations across databases, spot space utilization issues, understand cost distribution, and get a bird's-eye view of your database health and resource consumption.
Details Tab - A single-database deep dive that displays detailed configuration, performance metrics, space utilization, transaction patterns, and table-level statistics for a specific database. Use this view when troubleshooting issues, planning capacity changes, analyzing costs, or reviewing a specific database's configuration and growth patterns.
Key Capabilities
Monitor Database Health and Availability
Track database status (online, offline), configuration settings, and operational characteristics across your environment. Quickly identify databases experiencing issues or requiring attention.
Analyze Space Utilization and Growth
Review database space allocation, free space availability, and historical growth trends. Identify databases approaching capacity limits, understand data file and transaction log patterns, and plan storage expansion proactively.
Track Costs and Resource Consumption
Understand the financial impact of individual databases with integrated FinOps metrics. Track costs at the database level to optimize spending and align database resources with business value.
Ensure Configuration Compliance
Monitor database features (Availability Groups, Change Data Capture, Log Shipping, Transparent Data Encryption), compatibility modes, and collation settings across your environment. Ensure databases meet your organization's standards and security requirements.
Optimize Performance
Review transaction throughput patterns, identify high-cost queries, analyze table sizes and record counts, and understand resource consumption patterns to optimize database performance.
Manage Backup Compliance
Track last backup times for full and transaction log backups. Quickly identify databases that haven't been backed up recently or may be at risk of violating recovery point objectives.
Navigating the Dashboard
Filtering Your View
The Database Dashboard uses a unified filtering approach to help you focus on specific databases or groups:
- Views - Select from pre-configured views to quickly filter databases based on common criteria
- Tag - Filter databases by applied tags (Environment, application, project, etc.)
- Filters - Access the comprehensive filter panel with expandable sections for granular filtering options:
- Instances
- Databases
- Reset - Clear all active filters to return to the default view
- The Reset does not impact the date selections
Applied filters persist as you switch between any pages in WISdom, helping you maintain context as you explore your infrastructure. Note that the Details tab requires the selection of both an instance and a database. If multiple instances and/or databases are selected in the Overview tab, you'll need to refine your filter when switching to the Details tab.
Date Selection
The Date Picker in the upper right corner controls the point-in-time for configuration and space metrics.
How the Date Picker Works:
- Select any date up to today to view database configuration and space utilization as of that date
- WISdom collects database metrics daily, so you'll see the database's state as of the last successful collection on or before your selected date
- Historical growth charts reflect space utilization at your selected date and show trends leading up to that point
What the Date Picker Affects:
- Database space allocation and utilization metrics
- Data file and transaction log free space percentages
- Database Space Utilization Over Time charts (displays trend ending at selected date)
- Database configuration properties and feature settings
What the Date Picker Does NOT Affect:
- Transaction volume metrics (always display recent activity)
- Query performance statistics (always show recent patterns)
- Backup timestamps (always display the most recent backup times)
Need historical performance data?
To analyze query performance metrics for specific date ranges, use the Query Statistics or Performance pages, which offer full date range flexibility.
Choosing Your View
Start with Overview when you want to:
- Monitor multiple databases simultaneously
- Identify trends and patterns across your environment
- Compare space utilization, costs, and configurations across databases
- Find databases that need attention based on space, growth, compliance, or cost metrics
- Review database feature adoption (TDE, CDC, RCSI, etc.) across your environment
- Generate lists of databases meeting specific criteria
Switch to Details when you want to:
- Investigate a specific database's configuration and performance
- Review detailed space utilization and growth patterns
- Analyze transaction throughput trends over time
- Identify top resource-consuming queries for the database
- Review table sizes and record counts
- Understand data file and transaction log allocation
- Troubleshoot space or performance issues for a specific database
What's Next?
For detailed information about the cards, metrics, and features available in each view:
- Database Dashboard - Overview - Complete guide to the Overview tab
- Database Dashboard - Details - Complete guide to the Details tab
For information about filtering options and saved views:
- Tools - Documentation for Views, Tags, and Filters