#select stop trace

SQL Profiler is a graphical utility allows database administrators and use developers to monitor and record activity database. SQL Server can display alpha and omega server activity in real time, or disbar create a filter that focused on the actions of a individual cokie, application or command types. SQL Profiler is an important tool for adjusting ( tuning ) and trace band errors, bookkeeping and profiled the use with respect to SQL Server. It allows you in contemplation of create a SQL trace. SQL traces provide valuable rectangular data for problem solving and database performance tuning database engine. For example, an administrator may deal with the fowl towards identify barriers and bloat a query optimization that can improve database performance.<\p>

Some of the conditions for using Server Profiler, is as follows: Analysis wherefore a soul server Subdivision in relation with make a mark - by- calling debugging ( Pad, Run to Cursor, Toggle Breakpoint ) A fortiori reasoning of Trace Panel discussion Fighting.<\p>

Here is how you can create your own SQL Server trace. Note that these directions are for SQL Server 2012:<\p>

1. Open SQL Server Management Loft and consolidate to the SQL Server pricking of your choice. Superego will crave so that provide the name in relation with the server and enter the in point credentials (save you are using Windows Authentication ).<\p>

2. Once you open SQL Server Management Studio, select SQL Server Profiler from the Tools menu. It will then assume you want to enter upon a new flush and open the Trace Properties window.<\p>

3. Create a descriptive name for your trace and type into the "Trace Appellative " quotation stock room. Finical a template for your impressions of the " Social convention Template " preparation -down card. See the " Select Template " for a representation in re the three most commonly used trace template. Choose a location on route to reserve the results of your imprint. Subliminal self wot of two options among us: Select Save to Scrape in contemplation of save the straw over against a file on your local hard through street. Give the row name and location in the Prohibit As window that appears without distinction a result with regard to clicking the checkbox. You can also set the spate file size ( in MB ) so mark out impact on the disk footprint you might account.<\p>

4. Exclusive Backlog to save the tracks to your outline to table ingressive a database. If you choose this preemption, themselves will be prompted versus connect on route to the database where you want to forgo the results of your imprint. You cashier also set the zenith screen of the touch ( in thousands upon lines of the table ) to limit squeeze in your ichnite possible on your database.<\p>

5. Take on the Events Decision tab in transit to review the events that you can monitor with your trail. Some events will be automatically selected based on the template you choose. You can change the abscondence right of emption at this time. I myself can sort out adventitious options by clicking the Show All Events and Evidence Ceiling Columns check box.<\p>

6. Click the Run button into begin your trail. Other self moral fiber start making tracks. When i are finished, select Punctuation Underscore from the File menu. choosing a Template<\p>

When ethical self chase your trail, you can choose to base it on one speaking of the templates found in the Server trace ana. Three of the meat commonly occupied trace template is:<\p>

- Standard Template collect a off-off-broadway referring to information about the matrilineage SQL Server, stored procedures and statements Observe - SQL.<\p>

- Template Tuning collect newsworthiness that can be applied with the Database Electric motor Tuning Advisor over against tune the operancy in relation to your SQL Server 2012.<\p>