Dimitri Furman

Results 3 comments of 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.