http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Awesome! Similar to @Nick's comment above, I've found that I end up using the text-based query plan in SSMS (the one that displays it as if it were in an ASCII TreeView, 'SET SHOWPLAN_TEXT') instead of the graphical one, especially for large queries. Otherwise, I tend to lose track of what I'm looking at despite SSMS's zoom capabilities. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment13http://ayende.com/4406/profiler-speculative-feature-query-plans#comment13Tue, 23 Feb 2010 22:13:16 GMTKoen, Yes, I know, working on it http://ayende.com/4406/profiler-speculative-feature-query-plans#comment12http://ayende.com/4406/profiler-speculative-feature-query-plans#comment12Tue, 23 Feb 2010 20:34:53 GMTWow - this will make a great addition! Very much looking forward to not having to switch between this and my sql management studio! http://ayende.com/4406/profiler-speculative-feature-query-plans#comment11http://ayende.com/4406/profiler-speculative-feature-query-plans#comment11Tue, 23 Feb 2010 18:16:31 GMTI like the cost comparison 43% / 57 % in SSMS. Please, consider something like this. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment10http://ayende.com/4406/profiler-speculative-feature-query-plans#comment10Tue, 23 Feb 2010 16:42:58 GMTAwesome, Ayende. This is an awesome news! http://ayende.com/4406/profiler-speculative-feature-query-plans#comment9http://ayende.com/4406/profiler-speculative-feature-query-plans#comment9Tue, 23 Feb 2010 13:50:36 GMT:( Wish it wasn't so expensive. Would be handy. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment8http://ayende.com/4406/profiler-speculative-feature-query-plans#comment8Tue, 23 Feb 2010 12:29:11 GMTThis is pretty sweet. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment7http://ayende.com/4406/profiler-speculative-feature-query-plans#comment7Tue, 23 Feb 2010 12:26:01 GMTFact: One out of two times I open the profiler (ok, I might not use it sufficiently), my version is too old and I have to download a new ZIP file and overwrite most files. Quote: "Don’t discount the last one, making it easy is one of the core values of the profiler." Point: You might wanna think about adding an auto-update feature... Also: Query plans is gonna be cool br's http://ayende.com/4406/profiler-speculative-feature-query-plans#comment6http://ayende.com/4406/profiler-speculative-feature-query-plans#comment6Tue, 23 Feb 2010 10:25:49 GMTNick, You can only escape complexity for so long. It work nicely, and you get the entire screen to play with, but if it is big, you'll still need to navigate it http://ayende.com/4406/profiler-speculative-feature-query-plans#comment5http://ayende.com/4406/profiler-speculative-feature-query-plans#comment5Tue, 23 Feb 2010 10:00:36 GMTBarry, One step at a time, first, let us get this working, then we can start thinking about guidance. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment4http://ayende.com/4406/profiler-speculative-feature-query-plans#comment4Tue, 23 Feb 2010 09:59:47 GMT@Barry I second that! Would be nice if there could be warnings on the query plan with suggestions! http://ayende.com/4406/profiler-speculative-feature-query-plans#comment3http://ayende.com/4406/profiler-speculative-feature-query-plans#comment3Tue, 23 Feb 2010 09:27:37 GMTI would definitely use this feature. Once you've reduced the number of queries you make, optimizing the query itself is the next step if you can't or don't want to change your model. How well does the UI scale with large query plans? One of my problems with the SSMS UI is that large query plans are a pain in the rear end to navigate. We sometimes have entities that reach into legacy DBs through views, and I find that the query plans for complex queries over those entities are sometimes unbearable through the SSMS interface. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment2http://ayende.com/4406/profiler-speculative-feature-query-plans#comment2Tue, 23 Feb 2010 08:46:10 GMTCool... but is it information that is actionable? This would be most useful if you try and provide hints about the plan and perhaps a little guidance as to how NHibernate can help or just what dabatase structure works well for NHibernate. http://ayende.com/4406/profiler-speculative-feature-query-plans#comment1http://ayende.com/4406/profiler-speculative-feature-query-plans#comment1Tue, 23 Feb 2010 08:36:06 GMT