Vishal's Server SQL Info Dashboard

Member
5313 Views
Highlighted
Member
Posts: 82
Registered: ‎06-25-2015

Vishal's Server SQL Info Dashboard

[ Edited ]

Click here to read complete story about this dashboard on my 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

 

 

 

 

Vishal Pawar
Solution Architect
MCSC, MCTP, CSM
BI Blog-Business Intelligence Mentalist
SQL Blog-SQL Server Mentalist
Founder & Leader of Global Power BI User Group
vpawar@aptude.com | www.aptude.com