Supratimas – analysis tool for Microsoft SQL Server query execution plans

I found the GREATEST tool ever.. for analyzing SQL Server Query Plans.  I can’t wait to spend some more time with this!

http://supratimas.com/

FEATURES
Color Coding
Nodes with cost of more than one per cent are colored blue. That makes it easier to find them.

Output
Display number of rows and total size of data produced by the node.

Navigation
Easily move between nodes using navigation buttons. Center on node by double-click.

Incoming Cost
Show the cost of incoming subtrees. You can optionally collapse a subtree that is of no interest to you.

In-place properties
Show the cost of incoming subtrees. You can optionally collapse subtree that has no interest to you.

Rule-based warnings
Supratimas has a customizable, rule-based warning system. It can point to potential problems that lead to performance problems.

Warnings Summary
List of all warnings with an ability to navigate to the node.

Expensive Operations Summary
List of all nodes that have a cost of more than one cent.

http://supratimas.com/

This entry was posted in SQL Server and tagged , , , , , . Bookmark the permalink.