• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

tool to calculate statistics on tsql SELECT query

is there a tool that scan a big query and tell statistics as to how many SELECTs, GROUPS, how many columns retrieved to bring the results, how many joins, how many orders, distincts, how many rows read to bring the results etc.
0
25112
Asked:
25112
2 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I had a performance tuning class where the instructor introduced us to freeware SQL Sentry Plan Explorer , which allows you to see the multiple execution plans and various stats on multiple queries in a Stored Procedure.  Pretty damn handy.

I need to dig into this tool deeper.
Also, I think the freeware part has certain limitations, whereas when you purchase a license it has no limitations.

Good luck.
0
 
PortletPaulCommented:
"how many orders, distincts"...
yikes, hopefully only one order (at the end)

and distinct only ever used in a very limited way.
see: Select Distinct is returning duplicates ... look for the "Hail Mary Distinct"

"how many rows read to bring the results"
for this you do want the explain plan, and those numbers get displayed better using  SQL Sentry Plan Explorer
0
 
25112Author Commented:
will use it. thanks.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now