Difference between revisions of "SQL Profiler"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
(New page: __TOC__ ==Overview== Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. You can capture and sa...)
 
Line 5: Line 5:
 
To run SQL Server Profiler, on the '''Start''' menu, point to '''All Programs''', '''Microsoft SQL Server 2005''', '''Performance Tools''', and then click '''SQL Server Profiler'''.
 
To run SQL Server Profiler, on the '''Start''' menu, point to '''All Programs''', '''Microsoft SQL Server 2005''', '''Performance Tools''', and then click '''SQL Server Profiler'''.
  
''Compliments of Microsoft MDSD'' [http://msdn.microsoft.com/en-us/library/ms181091.aspx Introducing SQL Server Profiler]
+
''Compliments of Microsoft MSDN'' [http://msdn.microsoft.com/en-us/library/ms181091.aspx Introducing SQL Server Profiler]
  
 
==Tips & Tricks to solve Touchworks Issues==
 
==Tips & Tricks to solve Touchworks Issues==

Revision as of 15:41, 10 September 2008

Overview

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. You can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly.

To run SQL Server Profiler, on the Start menu, point to All Programs, Microsoft SQL Server 2005, Performance Tools, and then click SQL Server Profiler.

Compliments of Microsoft MSDN Introducing SQL Server Profiler

Tips & Tricks to solve Touchworks Issues