Invalid object name 'sys.master_files'.

[pegatim]

Ran the script against an Azure SQL DB and got the error:

Invalid object name 'sys.master_files'.

Any idea? Thanks!

[dimitri-furman]

@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, etc., it would not produce expected results because some assumptions it makes are only valid for Managed Instance.

[pegatim]

Ah, dang, Azure SQL DB needs a way to show when any throttling is occurring. Thanks though!

[dimitri-furman]

You can determine that by taking snapshots of sys.dm_io_virtual_file_stats() and looking at the diffs of io_stall_queued_read_ms and io_stall_queued_write_ms.

[pegatim]

Right on! Thanks for your help!!!