Soci (Soczó Zsolt) szakmai blogja

2007.04.29.

SQL Server Profiler, Server processes trace data

Filed under: Adatbázisok,SQL Server,SQL Server 2005,Szakmai élet — Soczó Zsolt @ 15:24

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.

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress