Sql Server Profiler (edit)

use [test]
go

select * from [TestDetails] order by RowNumber DESC

select * from [Test] where 
 RowNumber < 7983
 AND TextData not like 'declare%'
 AND TextData not like 'SELECT%'
 AND TextData not like 'IF%'
 AND TextData not like 'exec sp_executesql%'
 AND TextData not like 'exec GetLanguag%'
 AND TextData not like 'exec GetAllLanguag%'
 AND (
 TextData like '%get%'
 OR TextData like '%save%'
 OR TextData like '%insert%'
 OR TextData like '%delete%'
 OR TextData like '%upsert%'
 )

https://hackernoon.com/sql-server-profiler-best-practices-and-tuning-advisory-d8c746f54809

https://www.red-gate.com/simple-talk/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/

https://blogs.sap.com/2013/07/09/how-to-capture-queries-tables-and-fields-using-the-sql-server-profiler/

https://dzone.com/articles/what-is-sql-server-profiler-how-it-works-best-prac

https://community.ivanti.com/docs/DOC-39982

1. Tạo template để sử dụng lại

2. Tạo Trace từ template và lưu kết quả ra bảng khác

3. Query từ bảng kết quả sẽ được những thông tin để xử lý

4. Tinh giảm kết quả