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!
“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.”
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:
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.
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® 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.
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.