Click on the banner to learn about and purchase my database training on Azure

SQL Server - How to improve the output formatting of queries combined with SET STATISTICS IO and TIME

Views: 971 views
Reading Time: 3 minutes

Hello everybody!
All quiet with you?

In this post, I would like to present to you a very useful tool in the daily life of those who work with Performance Tuning and constantly need to enable the STATISTICS TIME and / or IO options to view some information about these queries that may assist in the activity of query optimization (Want some tips on Performance Tuning? Access this post).

Anyone who has used these parameters of the SET command knows that often, the formatting of the output is not very intuitive, especially when there are several queries in the statement, using several tables, making it difficult to understand this information.

To help us in this Performance Tuning study, Richie Rump has developed a web application where you paste the output from the Messages tab of SQL Server Management Studio (SSMS) and this tool converts the information into HTML table format, allowing you to view it. clear, objective and clean, and breaking, allowing us to sort the information, as by the amount of logical reads, for example.

If you want to know and start using Statistics Parser, just access the link

Example of use

I will demonstrate a practical example of how the Statistics Parser tool makes it easy to parse this output.


Output Using the Statistics Parser Tool

Other alternatives

If you are looking for other, more complete alternatives to Statistics Parser, I recommend SQLSentry Plan Explorer, an excellent tool that I personally enjoy and use whenever I need to optimize a query (soon I will post only about it)

Example of use

That's it folks!
Hope you enjoyed this post, a hug and see you next time!