Utolsó SQL 2005 vizsgára készülve találtam egy érdekeset a Profiler kapcsán, a trace beállításainál:

“Server processes trace data
Specify that the server running the trace should process the trace data. Using this option reduces the performance overhead incurred by tracing. If selected, no events are skipped even under stress conditions. If this check box is cleared, processing is performed by SQL Server Profiler, and there is a possibility that some events are not traced under stress conditions.”

Azaz nagyon durva terhelés esetén, ha nem akarunk elveszíteni egy eventöt se, ikszeljünk.

Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.