SQL Server Trace

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 Performance Advisor a try free for 15 days and see what Quick Trace can do!

Let's get started

SQL Trace

“One of my favorite things about Plan Explorer is the ability to copy the plan's XML and paste it in. When I'm working in client environments and they don't have PE installed, it's incredibly helpful.”

Erin Stellato

SQL Server Trace

SQL Server Profiler is used to build and manage SQL 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 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 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 Performance Advisor, takes all of the frustration and headaches out of tracking down performance problems that come with SQL Profiler trace and Activity Monitor.

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again