Query Azure WADLogsTable
When you have Azure WADLogTable loaded with tons of records, queries takes longer time to return results by using TimeStamp. WADLog Table index by partition key and if I query by partition key I see logs are returning way faster. Partition key is datetime in ticks, you can get datetime in ticks by converting datetime string into ticks. I’m lazy to open VS just to get datetime in ticks and use LINQPad tool for these kind of quick conversions. It’s kind of opening notepad and writing C# statements. Code to get datetime in Ticks: DateTime dt = new DateTime( 2013 , 08 , 29, 0,0,0 ); long l = dt.Ticks; Console.WriteLine(l); //gives 635133312000000000 Once you have datetime string in ticks prefix 0 , use that value to query the table & you can start see logs immediately. Query to Table – PartitionKey gt '0635133312000000000' If you want to see errors in log file use query with level = 2. PartitionKey gt '06