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!