Science, Tech, Math › Computer Science How to Create a Trace With Profiler in SQL Server 2008 Track specific database actions with a trace Share Flipboard Email Print Science, Tech, Math PHP Programming Perl Python Java Programming Javascript Programming Delphi Programming C & C++ Programming Ruby Programming Visual Basic View More By Mike Chapple Mike Chapple Writer University of Idaho Auburn University Notre Dame Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. Learn about our Editorial Process Updated on February 25, 2021 What to Know Go to Start > SQL Server Profiler > File > New Trace. Enter connection details and choose Connect. Add a name to the Trace Name box. Choose a template and select Save to File. Click the Events Selection tab to review the events, then choose Run to begin the trace. Instructions differ for SQL Server 2012. SQL Server 2008 is no longer supported. We recommend updating to a modern version. 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. We show you how to create a trace using SQL Server 2008 and earlier. 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. Cite this Article Format mla apa chicago Your Citation Chapple, Mike. "How to Create a Trace With Profiler in SQL Server 2008." ThoughtCo, Nov. 18, 2021, thoughtco.com/creating-trace-with-sql-server-profiler-1019869. Chapple, Mike. (2021, November 18). How to Create a Trace With Profiler in SQL Server 2008. Retrieved from https://www.thoughtco.com/creating-trace-with-sql-server-profiler-1019869 Chapple, Mike. "How to Create a Trace With Profiler in SQL Server 2008." ThoughtCo. https://www.thoughtco.com/creating-trace-with-sql-server-profiler-1019869 (accessed June 2, 2023). copy citation