You can download and install SQL Azure Diagnostics tools from
http://csssqlazure.blob.core.windows.net/csssqlazuredeploy/publish.htm
Click “Install” to download the setup, After download, run the setup
Click “Install” to proceed
After Install, Start “CSS SQL Azure Diagnostics”
Please provide SQL Azure server name, Database name, User name and Password and then click “Go”
Now you should able to view the following reports
1. Top 10 CPU Consuming Queries
2. Top 10 time taking Queries
3. Top 10 Logical I/O consuming queries
4. Top 10 Physical I/O Consuming Queries
You can export the report to Excel, PDF or Word
You can also print the report.
Thanks to Microsoft Customer Service and Support (CSS) SQL Support for providing such a nice tool freely !!!
SQLXpertise 