Host Dashboard
The Environment - Hosts pages have been renamed and moved to the new Dashboard section of WISdom
The Host Dashboard provides comprehensive visibility into your SQL Server infrastructure at the host level. This dashboard helps you monitor server health, track resource utilization, identify capacity planning opportunities, and ensure your environment meets operational and compliance standards.
What You'll Find Here
The Host Dashboard gives you two complementary views of your infrastructure:
Overview Tab - A multi-host view that shows aggregated metrics and trends across your entire environment or filtered subset of hosts. Use this view to identify patterns, compare performance across tiers, spot outliers, and get a bird's-eye view of your infrastructure health.
Details Tab - A single-host deep dive that displays detailed configuration, performance metrics, and recommendations for a specific server. Use this view when troubleshooting issues, planning capacity changes, or reviewing a specific host's configuration and health.
Key Capabilities
Monitor Infrastructure Health
Track host availability, alert status, and uptime across your environment. Quickly identify hosts experiencing issues or requiring attention.
Plan Capacity
Review CPU, memory, and storage capacity recommendations based on 30 days of performance data. Identify hosts that are over-provisioned or under-provisioned to optimize resource allocation.
Track Compliance
Monitor patch compliance status and ensure hosts meet your organization's security and maintenance standards.
Analyze Resource Distribution
Understand how hosts are distributed across environments (Production, QA, Development), tiers of service, operating systems, and data collectors.
Assess Performance
Identify storage performance issues by reviewing disk latency metrics across drives and mount points.
Navigating the Dashboard
Filtering Your View
The Host Dashboard uses a unified filtering approach to help you focus on specific hosts or groups:
- Views - Select from pre-configured views to quickly filter hosts based on common criteria
- Tag - Filter hosts by applied tags (Tier of Service, Environment, etc.)
- Filters - Access the comprehensive filter panel with expandable sections for granular filtering options
- 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 a single host. If multiple hosts 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 configuration data only. Performance metrics always display from today's date.
How the Date Picker Works:
- Select any date up to today to view configuration snapshots (CPU, memory, disk specifications, instance, or database configuration settings) from the most recent collection on or before that date
- WISdom collects configuration data daily, so you'll see the host's setup as of the last successful collection within your selected timeframe
Performance Metrics Display:
Performance charts show data from today's date going backward, regardless of your date picker selection:
- Monthly metrics display the previous 30 days from today
- Annual metrics display up to 1 year from today (or from the collection start date if monitoring began recently)
- Tables displaying annualized data will be labeled accordingly
To analyze 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 hosts simultaneously
- Identify trends and patterns across your environment
- Compare metrics across tiers of service or environments
- Find hosts that need attention based on capacity, compliance, or health metrics
- Generate lists of hosts meeting specific criteria
Switch to Details when you want to:
- Investigate a specific host's configuration and performance
- Review detailed capacity planning recommendations for a single server
- Check a host's build details, processor configuration, or network settings
- Understand instance and database allocation on a particular host
- Troubleshoot alerts or performance issues for a specific server
What's Next?
For detailed information about the cards, metrics, and features available in each view:
- Host Dashboard - Overview - Complete guide to the Overview tab
- Host Dashboard - Details - Complete guide to the Details tab
For information about filtering options and saved views:
- Tools - Documentation for Views, Tags, and Filters