{"id":106,"date":"2012-02-02T02:46:37","date_gmt":"2012-02-02T02:46:37","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=106"},"modified":"2014-03-06T15:38:22","modified_gmt":"2014-03-06T15:38:22","slug":"client-statistics","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/client-statistics\/","title":{"rendered":"Client Statistics"},"content":{"rendered":"

A feature often overlooked while tuning queries is Client Statistics located right on SSMS editor bar.<\/p>\n

\"SQL<\/a>
\nOther ways of opening Client Statistics include:<\/p>\n

SHIFT + ALT + S and Menu Bar \u2013 Query -> Include Client Statistics<\/p>\n

\"SQL<\/a><\/p>\n

Client Statistics is useful when the user needs to gather information about execution times, processing times, the amount of data sent between client and server, etc. it\u2019s very easy to use. Simply turn it on using one of the methods above and execute your query.<\/p>\n

In this example I\u2019m using the following query:<\/p>\n

\n
SELECT pc.FirstName\r\n,pc.LastName\r\n,pc.EmailAddress\r\n,he.Title\r\n,hh.Rate\r\nFROM Person.Contact pc\r\nJOIN HumanResources.Employee he ON pc.ContactID = he.ContactID\r\nJOIN HumanResources.EmployeePayHistory hh ON he.EmployeeID = hh.EmployeeID\r\nWHERE hh.Rate > 10\r\nORDER BY hh.Rate<\/pre>\n<\/div>\n
After executing the query you will notice a new tab labeled Client Statistics:<\/p>\n
\"SQL<\/a><\/p>\n
After looking at the statistics provided for Trial 1 you can see the processing time = 39ms, execution time = 46ms, etc.<\/p>\n
After the running the same query again I get the following results under Trial 2:<\/p>\n
\"SQL<\/a>
\nThis time processing time went up to 45ms and execution time went up to 51ms. It also has an average column to compare overall results. The green and red arrows represent differences between trials. Green arrows indicate improved statistics and red arrows indicate degrading statistics.<\/p>\n
A max of 10 trials can be run with the 11th<\/sup> trial dropping the 1st<\/sup> trial and so on. To reset statistics, on the menu bar, go to Query, Reset Client Statistics.<\/p>\n
\"SQL<\/a>This is great when tuning indexes because you can see different statistics as you add\/delete indexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
A feature often overlooked while tuning queries is Client Statistics located right on SSMS editor bar. Other ways of opening Client Statistics include: SHIFT + ALT + S and Menu Bar \u2013 Query -> Include Client Statistics Client Statistics is useful when the user needs to gather information about execution times, processing times, the amount […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[97,39,18,57],"class_list":["post-106","post","type-post","status-publish","format-standard","hentry","category-performance-tuning","tag-performance-tuning","tag-ssms","tag-statistics","tag-tuning"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/106\/revisions"}],"predecessor-version":[{"id":112,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/106\/revisions\/112"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}