Free SQL Azure Diagnostics Tool has been released !!!

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 !!!