Discussion concerning the free SQL Sentry Plan Explorer
9/19/2011 3:26:14 AM
cfeied
Posts: 5
|
The SSMS add-in makes SQL Sentry an absolute joy to work with!
If you were to offer a paid version of SQL Sentry I would be standing in line to buy it. I now consider it an *essential* part of my work.
I'm wishing for the same power and right-click convenience when opening query plans captured from the profiler. Is that a possibility?
|
|
0
• permalink
|
9/19/2011 2:58:27 PM
Jason Hall
Moderator
Posts: 267
|
Hi Craig,
I'm sorry that we don't actually have plans to attempt to integrate with SQL Profiler for launching Plan Explorer, but to build on your previous post, I wanted to say that we do actually have a very full featured commercial performance and event monitoring product for SQL Server.
I believe that SQL Sentry Performance advisor is really what you're looking for here. While capturing Top SQL and Running SQL, Performance Advisor will also collect the estimated plan at the time of execution. This is similar to what profiler is doing, but actually a lot better, since you'll have all of the features of Plan Explorer built into the SQL Sentry console, and you'll have the complete SQL text and statistics that were captured along with the trace data. Best of all, you'll be capturing this information for later consumption without having to actively set up your trace every time.
I could go on and on, but there is a web page that already goes over the features available. You can download a trial version, and request a live demo from one of our technical staff as well.
You can click here to read all about SQL Sentry Performance Advisor.
--
Jason Hall, SQL Sentry Support, SQL Sentry, Inc.
P: 704.895.6241 | F: 704.895.8771
|
|
0
• permalink
|
9/19/2011 3:27:13 PM
GregGonzalez
Moderator
Posts: 145
|
Hi Craig,
To echo what Jason said, I don't see us doing this simply because we already do all of this and more with Performance Advisor, and much better ;-) Performance Advisor automatically retrieves plans only for the queries that exceed our Top SQL trace filter thresholds (which you can adjust). This has a minimal impact on performance, and these are typically the plans you really want to see. Then with one click you are into the plan with full call stack and actuals metrics.
With Profiler you can't filter the plan events by duration, CPU, or IO, so it's all or nothing -- if you enable them, you capture *all* plans for *all* queries, even those that are already performing well. You then have to manually correlate the plan rows with the query rows that generated them, which can be very tedious. This can also have a big impact on performance, so you can usually only do it for short bursts... which means you may not capture the plans you really need.
For more info on differences between free Plan Explorer and Performance Advisor, see my post on this topic.
Thanks,
Greg Gonzalez
SQL Sentry
|
|
0
• permalink
|