SQL Query Datasource (T-SQL)

Question

I have a T-SQL query for showing disk IO stats (from 'sys.dm_io_virtual_file_stats'). I'd like to present this table data to a widget on a dashboard.

What is the best/most efficient way of doing this? This is something I've not explored before (T-SQL specifically), but have done similar with custom PowerShell/WMI/Groovy so the principle knowledge is good.

Thanks

patrick_rouse · Answer

To conceptualize how to accomplish this, you might consider reviewing our official Microsoft SQL Server DataSources, like Microsoft_SQLServer_DatabaseFiles or Microsoft_SQLServer_DatabaseStorage.

Forum Discussion

SQL Query Datasource (T-SQL)

1 Reply

Recent Discussions

SQL Query Datasource (T-SQL)

Alert Escalation Throttle Auditing?

Others Having Challenges with Least Privilege (POLP)?

Module Raw Data

SQL Monitoring Troubles