I downloaded the SQL Server First Aid Kit from Brent Ozar's website. When I tried to run the sp_BlitzIndex script against my master database via Microsoft Sql Server Management Studio while logged in as the Azure database server level admin and I got the following error:
Msg 262, Level 14, State 18, Procedure sp_BlitzIndex, Line 18 CREATE PROCEDURE permission denied in database 'master'.
I successfully created the procedure on the database instance I wanted to test. When I executed the procedure I got an error stating:
Msg 50000, Level 16, State 1, Line 1265 Invalid object name 'mydatabase.sys.partitions'.
Next I tried to be clever and run the stored procedure code directly against the master database without creating the stored procedure and got the following error:
Msg 50000, Level 15, State 1, Line 1267 Reference to database and/or server name in 'mydatabase.sys.indexes' is not supported in this version of SQL Server.
I don't feel confident enough to start toying with the inner workings of ~2700 lines of index heuristic logic. Is there a quick, and easy way to get this stored procedure to work nicely on Azure SQL Database or should I look elsewhere for an index analyzing tool/stored procedure?