Archive

Posts Tagged ‘SQL Azure Performance Tuning’

Free SQL Azure Diagnostics Tool has been released !!!

April 28, 2011 Leave a comment

You can download and install SQL Azure Diagnostics tools from

http://csssqlazure.blob.core.windows.net/csssqlazuredeploy/publish.htm

image

Click “Install” to download the setup, After download, run the setup

image

Click “Install” to proceed

image

After Install, Start “CSS SQL Azure Diagnostics”

image

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

image

2. Top 10 time taking Queries

image

3. Top 10 Logical I/O consuming queries

image

4. Top 10 Physical I/O Consuming Queries

image

You can export the report to Excel, PDF or Word

image

You can also print the report.

Thanks to Microsoft Customer Service and Support (CSS) SQL Support for providing such a nice tool freely !!!

Advertisements
%d bloggers like this: