In a previous post we looked at the Windows Azure PaaS SDP package which allows you to quickly and easily gather all of the log data to determine root cause for a variety of PaaS compute issues. This post will look at a new SDP package which allows you to quickly and easily gather all of the storage analytics logs.
This package will only work on a Windows 7 or later, or Windows Server 2008 R2 or later computer.
md c:\Diagnostics; Import-Module bitstransfer; Start-BitsTransfer http://dsazure.blob.core.windows.net/azuretools/AzureStorageAnalyticsLogs_global.DiagCab c:\Diagnostics\AzureStorageAnalyticsLogs_global.DiagCab; c:\Diagnostics\AzureStorageAnalyticsLogs_global.DiagCab
Alternatively you can download and save the .DiagCab directly from http://dsazure.blob.core.windows.net/azuretools/AzureStorageAnalyticsLogs_global.DiagCab.
There will be several files created as a result of running this SDP package. The important ones are:
You can add or remove metrics from the Excel charts using the standard Chart filter tools:
You can easily filter and sort the .CSV files within Excel. The following filter can help identify potentially inefficient queries by identifying requests that take longer than X number of milliseconds on the server:
Look for additional blog posts in the future which walk through using the analytics data to identify and solve common issues.
http://msdn.microsoft.com/en-us/library/windowsazure/hh343270.aspx – In depth documentation about storage analytics and what each field means.
http://www.windowsazure.com/en-us/documentation/articles/storage-monitor-storage-account/ – How to enable and use metrics from the Azure Management Portal.
http://channel9.msdn.com/Series/DIY-Windows-Azure-Troubleshooting/Storage-Analytics – A short 5 and a half minute video showing how to enable and use storage analytics.
Thanks, very helpful