SSMS can do more than displaying your query results. It has great options to help you when you need to improve your query performances. Client Statics feature is one of these options SSMS comes with. This feature displays all kind of important statistics about your query. It works just like Execution plan option, you need to enable it and run your query to see the results. You can turn it on in couple of way.
Click on Include Client Statistics icon.
You can press Shift + Alt + S
Menu > Query > Include Client Statistics
You can see the results under Client Statistics tab. As you can see, I ran this query 4 times and It captured all data in each time. Client Statistics tab displays the last 10 trials.
Client Statistics Tips
All times are in milliseconds.
To reset the results click on Menu > Query > Reset Client Statistics
You may want clear the query cache by using DBCC DROPCLEANBUFFERS command in your query.
Client Statistics Tips
All times are in milliseconds.
To reset the results click on Menu > Query > Reset Client Statistics
You may want clear the query cache by using DBCC DROPCLEANBUFFERS command in your query.
No comments:
Post a Comment