Vishal's Server SQL Info Dashboard 04-13-2024 23:19 PM

[Anonymous]

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

eyJrIjoiODM3ZDAwZDItNDE1Zi00NGRhLWE5NTAtMGMzODRjZDZjMjMxIiwidCI6ImMyNmNlMTk0LWI4NDAtNGZjYy04YTY4LTAyYTM0MDc1NTNlMyIsImMiOjF9

[chandrra111]

Hi Vishal

The dashboard appears well-designed, offering comprehensive insights into the database. I'm currently engaged in similar analysis, and it would be immensely beneficial if you could share the PBIX file if feasible. Moreover, I'm curious whether you've explored employing Azure Synapse for similar tasks.

Regards,

Bala

[rguillen72]

Hi, Can you please share the PBIX?