Dimitri Furman
Dimitri Furman
Good idea. Let's wait until the code is more stable and mature and has some traction, and revisit at that point. Keeping this open.
@timlaipega The script is intended for Managed Instance, not for SQL Database. While it may be possible to make the script compile on SQL Database by replacing sys.master_files with sys.database_files,...
You can determine that by taking snapshots of [sys.dm_io_virtual_file_stats()](https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-file-stats-transact-sql) and looking at the diffs of io_stall_queued_read_ms and io_stall_queued_write_ms.