Statistics will be shown for the ten most recent executions, and they will be averaged, as shown in Figure 2.
That’s useful when you run a query once, but its usefulness becomes more apparent when you are tuning a query. The time statistics tells you how much time was spent processing on the client versus how much time was spent waiting for the server. The network statistics lets you see how much traffic is moving from your client to the server and back. You can see the number of rows affected or returned, and the number of transactions executed. Some really valuable information can be found here, such as the number of INSERT, DELETE, UPDATE, and SELECT statements – think of how useful that can be when tuning a complex stored procedure. Open a query editor window, click on it to highlight it, write a query, and execute it.
This button is located on the SQL Editor toolbar. I mentioned it in last week’s webcast, “ SSMS: More Than Meets The Eye“, but I wanted to give you more detail about it here. Select Reset Client Statistics from the Query menu to reset the average.” Statistics from successive query executions are listed along with the average values. When Include Client Statistics is selected from the Query menu, a Client Statistics window is displayed upon query execution. MSDN says it “Displays information about the query execution grouped into categories. At SQL Saturday #118 Wisconsin earlier this year, I was watching a presentation and the presenter clicked “Include Client Statistics”. However, SQL Server Management Studio (SSMS) has so many I haven’t gotten through all of them. I like clicking all the buttons in applications I work with.
#SQL SERVER CLIENT MANAGEMENT STUDIO MANUAL#
I have to read the user manual of everything I buy so I know all of its features.
0 kommentar(er)
