ueue lhs WHERE lhs.Processing_State = 'MATCHING' OR lhs.Processing_State = 'MATCHED' ORDER BY Last_Execution_Date ASC
0x030009003D00DA3FA6087C0182A200000100000000000000 SELECT Top 1 @ticketID = OperationLog_ID FROM GEDemo.dbo.OperationLog WHERE @rootOperationUID = Root_Operation_UID AND Status = 0 ORDER BY OperationLog_ID ASC
0x030009003D00DA3FA6087C0182A200000100000000000000 UPDATE MatcherService_MatcherQueue SET Last_Execution_Date = GETDATE() WHERE MatcherService_MatcherQueue_ID = @matcherQueueID
注意看起来一个sql_handle有三条语句,原因是这三条sql是属于同一个存储过程的。
5,我们可能还需要找出包含该sql的具体存储过程,然后进行优化。出了用sql查询外,推荐使用一个叫“SQL Search”的第三方工具,很方便,免费的:
http://www.red-gate.com/products/sql-development/sql-search/ utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqlsearch&gclid=COLe-MfA1b0CFRFp7Aod5jwAqw