SQL SERVER:事件探查器與Server-side Trace

SQL SERVER:事件探查器與Server-side Trace- use the GUI to define the template of the events and columns you want to track first, then script. that into the server side sql statements. Take some time with the GUI to test which events you capture and the rate at which they happen.- using fn_trace_gettable to read trace files.- SP:StmtCompleted I would not trace, it's too verbose. I would also skip SP:CacheHit. - Start with RPC:Completed and SQL:BatchCompleted events. We should first identify at the ...

Link URL: http://kitesky.itpub.net/post/909/498368