April 19, 2007 at 12:08 am
| Application Profile Statistics | Value | Average |
| Timer resolution (milliseconds) | 0 | 0 |
| Number of INSERT, UPDATE, DELETE statements | 0 | 0 |
| Rows effected by INSERT, UPDATE, DELETE statements | 0 | 0 |
| Number of SELECT statements | 2 | 1 |
| Rows effected by SELECT statements | 872722 | 436361 |
| Number of user transactions | 5 | 4 |
| Average fetch time | 0 | 0 |
| Cumulative fetch time | 0 | 0 |
| Number of fetches | 0 | 0 |
| Number of open statement handles | 0 | 0 |
| Max number of opened statement handles | 0 | 0 |
| Cumulative number of statement handles | 0 | 0 |
| Network Statistics | ||
| Number of server roundtrips | 3 | 3 |
| Number of TDS packets sent | 3 | 3 |
| Number of TDS packets received | 47272 | 23637.5 |
| Number of bytes sent | 198 | 198 |
| Number of bytes received | 1.94E+08 | 9.68E+07 |
| Time Statistics | ||
| Cumulative client processing time | 1 | 0.5 |
| Cumulative wait time on server replies | 29653 | 14826.5 |
Please explain me the above statics criterias. Also if possible please give me reference links.
April 19, 2007 at 7:53 am
Look at the topic "Query Window Statistics Pane" in SQL BOL.
April 19, 2007 at 10:21 pm
Thanks for your help.
But i had one more question, Will this statistics help in query tuning? How?
April 23, 2007 at 9:11 am
I prefer to use the query execution plan to provide the info I want to know but you can use all sttas are usefull if you are looking for a particular/potential bottleneck but I never had a specific need for these myself so you couldn't go on anything I tell you about them anyway.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply