Internet, Networking, & Security Web Development How to Create a Trace With Profiler in SQL Server 2008 Track specific database actions with a trace by Mike Chapple Writer Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Mike Chapple Updated on April 22, 2020 Web Development SQL CSS & HTML Web Design Tweet Share Email Traces allow you to track the specific actions performed against a SQL Server database. They provide valuable information for troubleshooting database errors and tuning database engine performance. This article is for users of SQL Server 2008 and earlier. Instructions differ for creating traces with SQL Server 2012. SQL Server 2008 is significantly out of date and no longer supported—we recommend updating to a modern version of SQL Server—but we retain these instructions for people locked into legacy database systems. How to Create a Trace With SQL Server Profiler Use SQL Server Management Studio to create a trace. Open SQL Server Management Studio by selecting it from the Start menu. From the Tools menu, choose SQL Server Profiler. When SQL Server Profiler opens, select New Trace from the File menu. SQL Server Profiler prompts you to connect to the SQL Server instance you wish to profile. Provide the connection details and click Connect to continue. Create a descriptive name for your trace and type it into the Trace Name textbox. Select a template for your trace from the drop-down menu. Select Save to File to save your trace to a file on the local hard drive. Provide a file name and location in the Save As window. Click the Events Selection tab to review the events you may monitor with your trace. Some events will automatically be selected based on the template you chose although you're free to modify those defaults. You may view additional options by clicking the Show All Events and Show All Columns checkboxes. Click the Run button to begin your trace. SQL Server creates the trace. When you are finished, select Stop Trace from the File menu. Template Tips The Standard template collects a variety of information about SQL Server connections, stored procedures, and Transact-SQL statements. The Tuning template collects information that may be used with the Database Engine Tuning Advisor to tune your SQL Server's performance. The TSQL_Replay template gathers enough information about each Transact-SQL statement to recreate the activity in the future. This template is useful to reconstruct queries to assess, for example, for inappropriate data access. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Please try again. Thank you for signing up. Tell us why! Other Not enough details Hard to understand Submit