THE SQL Server Blog Spot on the Web

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

Joe Chang

Free tools for SQL Server - Automating Execution Plan Analysis

Since this topic is being discussed, I will plug my own tools,
SQL Exec Stats and (a little dated) documentation

the main capability is cross-referencing index usuage with specific execution plans.
another feature is generating execution plans for all stored procedures in a database, along with the index usage cross-reference.

There are several sources of execution plans or plan handles,
this could be a live trace, a previously saved trace, previously saved sqlplan files,
from dm_exec_cached_plans, dm_exec_query_stats, etc
all are useful, so we need tools to make use of execution plans from all sources

I could also mention my own performance monitoring tool, which needs to be updated or incorporated into a commercial tool,
the point of note is that is shows disk IO from performance counters, and from fn_virtualfilestats with the data, log and temp read/write all simultaneously

Finally, there is SQL Clone, which started in SQL Server 2000, but in SQL Server 2005 and later, we have the API to get and update data distribution statistics.

Published Sunday, February 6, 2011 6:02 PM by jchang
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



AaronBertrand said:

Thanks Joe, I've added your tool to my list.


February 6, 2011 5:37 PM

PUB G said:

Now download the latest version application,how can id install file transfer application for PC now install now click here this visit and share this information.

February 19, 2019 2:35 AM

Leave a Comment


About jchang

Reverse engineering the SQL Server Cost Based Optimizer (Query Optimizer), NUMA System Architecture, performance tools developer - SQL ExecStats, mucking with the data distribution statistics histogram - decoding STATS_STREAM, Parallel Execution plans, microprocessors, SSD, HDD, SAN, storage performance, performance modeling and prediction, database architecture, SQL Server engine

This Blog


Privacy Statement