SQL Server 2012 notes Sharing -33:sql SERVER Profiler tracking

Demand

Use SQL Server Profiler to track all common activities of the current instance and save the results to a file.

================================================================

In the Start program, select SQL Server Profiler.

650) this.width=650; "title=" "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_1403313086k2fa.png "height=" 484 "/>

Select File-New trace,.

650) this.width=650; "title=" "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" "src=" http:// Img1.51cto.com/attachment/201406/21/639838_1403313089cirh.png "height=" 354 "/>

Connect to the current instance of SQL Server.

650) this.width=650, "title=", "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_1403313092h69s.png "height=" 355 "/>

In the Tracking property, configure the trace name, the file address to save to, save to the SQL report, enable trace stop time, and so on.

650) this.width=650; "title=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px "style="; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_1403313096gbo9.png "height=" 405 "/>

is a real-time tracking after the start of the situation,.

650) this.width=650; "title=" "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" "src="/HTTP// Img1.51cto.com/attachment/201406/21/639838_1403313104pfnb.png "height=" 398 "/>

We can open the previously saved trace file for analysis to view.

650) this.width=650; "title=" style= "border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_1403313107lalp.png "height=" 344 "/>

Select the trace file that you want to view.

650) this.width=650; "title=" style= "border-top:0px;border-right:0px;background-image:none;border-bottom:0px; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_14033131097z04.png "height=" 481 "/>

When opened,.

650) this.width=650; "title=" border-top:0px;border-right:0px;background-image:none;border-bottom:0px "style="; padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" src= "http:// Img1.51cto.com/attachment/201406/21/639838_1403313117iyds.png "height=" 305 "/>

=================================================================

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!