Bosses I by extending the event hold out slow SQL, SQL server can be slow query analysis, it is concluded that similar to merge similar statements of different parameters of the mysqldumpslow?
Such as:
Different parameters of slow query statement actually, merged into this, (similar to the statements in the dm_exec_query_stats, but inside the DMV is not too accurate, and if the query frequency is low, some statements are sometimes not)

SELECT [sr] FROM [bank] WITH (nolock) WHERE customerid=@ 1

CodePudding user response:

Using event detector tracking for a period of time, there is set up to track, and query stored procedures or other statements; Will track the data inserted into a table, then you can check the IO or duration of the CPU, a row under the order, will know that what kind of statement is slow; Then the optimized to solve these problems.