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?
1
votes
What would qualify as a better way? There are third-party tools like Azure Diagnostics Manager that are able to prune diagnostics data (e.g. by date) but I am not sure about any periodic cleanup.
– Simon Opelt
Thanks for the useful link. Please, post it as answer. Ideally, i'd prefer not to use 3rd party tools.
– Vladimir
2 Answers
1
votes
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.
0
votes
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.