SQL Query Datasource (T-SQL)

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

ldoodle

Posted 1 year ago·Last reply 1 year ago

2 comments

ldoodle

OP1 year ago

Thanks Patrick_Rouse I already did exactly that. I used the GlobalPerformance once and spawned off my own T-SQL inside that, replacing the original.

Works an absolute treat. I grouped the data per-instance rather than per-database otherwise the list would be huge for larger environments. It still gives you a nod to go and investigate.

1	SUYASH GAIKWAD
2	BM Brahim Merrouane
3	TH Tom Hester
4	RP Robert Poreba
5	RR Robin Ratcliffe
6	AH Alejandra Herrera