Query for timing info records

timing_info_query.sql

select * from Log
where ApplicationName != 'Q4Go' 
and SUBSTRING([Message], 0, 14) = '[TIMING INFO]'
order by Date desc

----

select * from Log
--where ApplicationName != 'Q4Go' 
--and SUBSTRING([Message], 0, 14) = '[TIMING INFO]'
-- where SUBSTRING([Message], 0, 7) = '[TIME]'
--and Logger = 'Q4Orion.NServiceBus.Decorators.EventReceivedHandlerDecorator`1[[Q4StockQuote.ServiceBus.Event.ReconcileXIgniteHistoricalStockQuoteEvent, Q4StockQuote.ServiceBus.Event, Version=1.0.0.938, Culture=neutral, PublicKeyToken=null]]'
--where ApplicationName != 'Q4StockQuote'
--where Level != 'INFO'
order by Date desc

-- SELECT SUBSTRING('[TIME]: Event GetLatestXIgniteStockQuoteEvent: StockSymbol=GBX.U, StockExchange=XTSE took 121 milliseconds', 1, 6)

--- truncate table Log