Number of server roundtrips – a roundtrip consists of a request sent to the server and a reply from the server to the client.
TDS (= tabular data stream) Packets sent from the client – TDS is the language which SQL Server speaks, and in order for applications to communicate with SQL Server, they need to pack the requests in TDS packets. TDS Packets sent from the client is the number of packets sent from the client; in case the request is large, then it may need more buffers, and eventually might even need more server roundtrips.
TDS packets received from server – the TDS packets sent by the server to the client during the query execution.
Bytes sent from client – the volume of the data set to our SQL Server, measured in bytes; i.e. how big of a query we have sent to the SQL Server.
Bytes received from server – the amount of data the SQL Server has sent to the client, measured in bytes. Depending on the number of rows and the datatypes involved, this number will vary.
Client processing time – the amount of time spent in milliseconds between the first received response packet and the last received response packet by the client.
Wait time on server replies – the time in milliseconds between the last request packet which left the client and the first response packet which came back from the server to the client.
Total execution time – the sum of client processing time and wait time on server replies (the SQL Server internal processing time).
Show/hide Client Statistics:
No comments:
Post a Comment