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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66009/viewspace-661781/，如需转载，请注明出处，否则将追究法律责任。