Get Started with AD2Excel

Getting started with AD2Excel is easy. Follow the steps below and you will be working with your Windows Azure diagnostics data before you know it!

Step 1: Getting your Azure Table Storage account info

An Azure cloud service can be set up to log performance data (read more about setting up Windows Azure Diagnostics on MSDN). Setting up Windows Azure Diagnostics (WAD) is required and is not done automatically by Azure. Once WAD has been set up, the WADPerformanceCountersTable on your Azure Table Storage account will be updated with performance information by your Azure instances. AD2Excel fetches performance data from this table for you to work with in Excel.

After having installed the AD2Excel add-in (which can be downloaded from the Downloads section), the first thing you will need is your Azure Table Storage account info. See the page in the Windows Azure documentation for a guide on how to find your Azure Table Storage account name and account key.

You will need the Storage Account Name and the Primary Access Key of the Table Storage service that you set up for WAD.

Step 2: Configure your Table Storage account in AD2Excel

Open Excel 2013 after having installed the AD2Excel add-in.

Click on Account Settings to add your Table Storage account.

Click on Add Account... to enter your account info.

Paste your Storage Account Name in the Account Name field and your Primary Account Key in the Account Key field. Click on Add Account. Click on Close in the Account Settings window.

Click on the Load from Azure Table Storage button.

Your newly entered account will show up in the accounts drop down list. Specify a time range (in the UTC time zone) and the list of performance counters you are interested in. You can read more about performance counters on the Windows Azure website.

Make sure that you are in a blank Excel worksheet, as AD2Excel will override the cells in the current worksheet. Click on Load Formatted Data to load the performance data into the currently active Excel worksheet.

Please note that downloading the diagnostics data may take several minutes. Let AD2Excel work until the "Load from Azure Table Storage" window has closed and you have been notified that the diagnostics data has been downloaded successfully.

Step 3: Start working with your diagnostics data

The diagnostiscs data with the given performance counters within the specified time period has been downloaded and inserted into your currently active Excel worksheet. You are now able to work with the diagnostics data, create chart and PivotTables, and analyze the performance of your Azure instances. Enjoy!

Last edited Aug 6, 2013 at 6:37 AM by sbrand, version 3

Comments

No comments yet.