SQL Trace

SQL Trace Explained

SQL Server Profiler is used to build and manage traces as well as evaluate and replay the SQL trace outcome. The events of the SQL Profiler trace are saved in a file that can be used to diagnose issues by rehashing specific sequences of steps. SQL Profiler is a visual interface to SQL Server trace for monitoring instances of Analysis Services or the Database Engine. The SQL Server Profiler trace allows you to capture and save data about every single event to a file to review at a later time.

Saving files for later analysis can be an extremely useful feature of the SQL Server trace. One example is monitoring a production environment to target stored procedures that are affecting server performance by running slowly. SQL Profiler trace can also have other uses such as the ones below:

  • Discovering and determining the cause of slow-running queries
  • Get to the root of problem queries by analysis
  • Tune workloads by monitoring SQL Server performance
  • Diagnose problems with corresponding performance counters
  • Capture T-SQL statements that are causing problems

Using a SQL Server trace may make troubleshooting performance problems seem easier. However, it can also be difficult to use with no filtering, and if the standard default template is used, it can put a high overhead on your servers. SentryOne Performance Advisor offers an easier way to run a SQL trace with less overhead as well as easier to view results.

SentryOne’s Quick Trace™ functionality allows you to run a full SQL Server trace and view all of the pertinent activity on your server. Quick Trace offers easy to read results with lower overhead and minimal impact to your server.

Give SentryOne a try free for 15 days and see what Quick Trace can do!

Download Trial
Quick Trace | SQL Server | SQL Sentry

SentryOne Quick Trace™

When you need to run a full SQL Server trace in an unfiltered view of the SQL activity on your server, Quick Trace is an excellent solution. Whether you are inquiring about long running or high-impact queries, or even short queries that can run thousands of times over a short time span, Quick Trace can provide an easy to read graphic view of all SQL activity. While it is similar to SQL Profiler trace and Activity Monitor, it is integrated into one easy to use tool. You can run a Quick Trace on demand, or you can set it up to be automated based on certain conditions like blocks or performance thresholds.

Quick Trace Benefits

  • Complete view of SQL Server processes by combining trace and process activity data
  • Totals for CPU, I/O, batches, network, transactions, recompiles, etc., are provided
  • No more constant starting and stopping in Profiler
  • No refreshing in Activity Monitor
  • No exhausting calculating and correlating of aggregates
  • Sort, filter and group metrics and zero in on the exact data you need

Quick Trace in SentryOne SQL Sentry takes all of the frustration and headaches out of tracking down performance problems that come with SQL Profiler trace and Activity Monitor.

“The more that I use SQL Sentry, the more I fall in love with it. #SQLSentry #LoveStory”

- John Morehouse, Consultant at Denny Cherry & Associates


Download and try SQL Sentry for free today!

Download Trial