Hi,

I have enabled the diagnostic data in cloud services and virtual machine. i have choose the one storage account for both these diagnostics. So all these datas are stored in same storage account. How can i differentiate which table for which service? because both cloud and virtual machine have WADPerformanceCounterTable and logs table etc..(or) both the data's are stored in same table?.if yes how can i differentiate the data's? Please give me some sugesstion..

Thanks & Regards,

Rat

Just by looking at the table names, I don't think you will be able to differentiate. You will need to look at the data. Especially look for "Role" and "RoleInstance" attributes and that will tell you for which role (Cloud Service or VM) this data is.

However, I would recommend using a separate storage account for capturing diagnostics data for each service. Given that now you can have 100 storage accounts / subscription, I don't think you will run out of storage accounts very soon. Also the management becomes easier if you have separate storage accounts. More importantly, each storage account has some upper limit in terms of scalability and putting data from different sources into just one storage account would put more stress on that account and the performance might degrade because of that.

Hope this helps.