How can tables created by Azure diagnostics (WAD*) be periodically cleanup? So far i've found only some powershell cmdlets. May be there is a better way?
Azure diagnostics cleanup
732 Views Asked by Vladimir At
2
There are 2 best solutions below
0

Windows Azure Scheduler is in preview version now.
One of the usages:
Daily maintenance: Web applications have needs such as daily pruning of logs, performing backups, and other maintenance tasks.
So, let's wait until release version.
There're some 3rd party tools which implement this functionality. One such tool is Cerebrata Azure Management Cmdlets using which you can automate diagnostics cleanup by creating some PowerShell script and scheduling them.
Since the diagnostics data is stored in Windows Azure Storage, you can write some code as well to clean up old data. When cleaning, please remember
NOT to query on Timestamp
. Instead use PartitionKey as it denotes a date/time value in Ticks.