careoreo.blogg.se

To show you some client statistics let’s run the following query while the “Include Client Statistics” option is enabled: USE AdventureWorks2019

Another way to turn on client statistics is to click on the “Include Client Statistics” button in the toolbar as shown below: When you turn on “Include Client Statistics”, the statistic will be displayed each time you execute your TSQL from a query window. One way to turn these on are to use the “Include Client Statistics” in the Query menu, as shown below:Īlternatively, you can use the “Shift+Alt+S” keyboard shortcut. To view client statistics, you need to turn on the “Include Client Statistics” option. With that in mind, this database tutorial will show you how client statistics work and explain how they might be useful when you are writing and debugging your TSQL code. If you are like me, you might be thinking something along the lines of “That really doesn’t help me understand exactly what client statistics are”. The second one said “…Displays information about the query execution grouped into categories”. One reference said “…contains statistics about the query and about the network packets, and the elapsed time of the query”. When I searched, I found only two references to these statistics. Do you know what client statistics are? If you search the Microsoft documentation, you may find the description a little lacking. In SQL Server Management Studio there is a view option known as “Include Client Statistics”.