THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Execution plans   (RSS)
Showing page 2 of 2 (20 total posts)
  • How to find missing indexes quickly in SQL Sentry Plan Explorer

    This question came up on twitter, and I thought a quick blog post would be better than a series of 140-character snippets. Management Studio does not do the best job at highlighting missing indexes. If you have a simple query plan that represents a single statement, no problem; however, if you have a plan that represents a multi-batch statement, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 17, 2011
  • SQL Sentry Plan Explorer : New release and an SSMS add-in

    Today we released a new build of SQL Sentry Plan Explorer. The build # is 6.2.34 and you can download it from the usual location. Plan Explorer Changes The updates in this release include the following: A new ''Check for Updates'' feature accessible via the Help menu: Other new additions to the Help menu: Enable/disable the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 3, 2011
  • A couple of fixes for Plan Explorer

    This evening SQL Sentry has pushed out a new build of Plan Explorer 1.2 (build #6.1.32), fixing a couple of minor issues brought to our attention by users. Eric Humphrey (@lotsahelp) pointed out that our query timeout for generating an actual plan was set to 30 seconds. This was an oversight, but chances are you wouldn't see this in most ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 26, 2011
  • Connect Digest : 2011-03-12

    Background Last year, I came to a very tough decision that I would cease publicizing Connect items in an attempt to drive up votes and get important issues fixed. This was almost entirely due to a couple of MVPs criticizing me for raising awareness of certain Connect items instead of letting them be found ''naturally.'' I wasn't sure what world ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 12, 2011
  • SQL Sentry Plan Explorer : Version 1.1!

    Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build 6.0.67.0). So, what's new?  Several wish list items have been fulfilled (hey, it is Christmas, after ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 22, 2010
  • SQL Sentry's Plan Explorer : a closer look

    Today I was digging more into SQL Sentry's Plan Explorer, and I continue to discover little things I think you will find valuable in your performance tuning and troubleshooting efforts. Let's say I am analyzing a plan for a relatively simple batch: SELECT * FROM sys.objects;CREATE TABLE #foo([object_id] INT, def NVARCHAR(MAX));INSERT ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 27, 2010
  • A first glimpse of SQL Sentry's Plan Explorer

    Yesterday, Greg Gonzalez (blog | twitter) announced a beta project for SQL Sentry's latest offering: Plan Explorer.  I have been playing with the early versions of the beta, and I can tell you that DBAs should be very excited about having this tool in their arsenal.  This is a free companion to SQL Server Management Studio that greatly ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 21, 2010
  • Automating SQL Execution Plan analysis

    Last year, I made my tool for automating execution plan analysis available on www.qdpma.com The original version could parse execution plans from sys.dm_exec_query_stats or dm_exec_cached_plans and generate a cross-reference of which execution plans employed each index. The DMV sys.dm_db_index_usage_stats shows how often each index is ...
    Posted to Joe Chang (Weblog) by jchang on March 22, 2010
  • The Query Optimizer and Cost Estimation

    Last year when I presented my session regarding the Query Optimizer at the PASS Summit and at a couple of local user groups, I was asked how the estimated CPU and I/O costs in an execution plan are calculated. Since Microsoft does not publish how these costs are calculated all I could say was that each operator cost depends on the operator ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on February 17, 2010
  • Automating Query Exec, Index Usage and Execution Plans, Update 2

    I have made updates to my tool for automating SQL Server query exec stats, index usage, execution plan analysis. So I would like people to give it a try and send feedback. If there is an error, please report the file and line number (the top level is sufficient). download at http://www.qdpma.com/tools/ExecStats.zip (check ...
    Posted to Joe Chang (Weblog) by jchang on July 13, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement