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.
LVL 5
25112Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PaulConnect With a Mentor Commented:
"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
 
Jim HornConnect With a Mentor Microsoft 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
 
25112Author Commented:
will use it. thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.