In this episode, watch Vishal guide you through his SQL Server Info Dashboard.
- Data Stories on Community Website
- Slides
- Detailed BI Blog
- Detailed SQL Query Blog
Summary
ALL SQL Server Information
Drive Info
Hardware info
Instance Information
SQL Server Start time
SQL Server Configuration Details
KPI
CPU Usage
Memory Usage
Disk Free Vs Total Space
Dashboard Evolved as
Dashboard is inspiration for DBA
Save time to know anything about SQL Server
Visualization of SQL Server information
Intention is to “To help DBA to know SQL Server info at a glance and monitoring”
Wh Question
Who -DB Admin and DB Devs
Where – This dashboard can use in real-time development and administration for any SQL Server information
When – On demand when you need to see all SQL server info at run time
Which – Is key column in table for Data modeling – name(Database name)
How – Dashboard has SQL Server Instance As Parameter