How to analyze client statistics output in ssms?

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  May 10, 2011 at 6:26 am

  #238008

  How to analyze client statistics output in ssms?

  Client Execution Time17:44:3917:39:0717:13:1516:33:1816:33:0716:32:5516:32:4316:32:2316:31:5916:31:26

  Query Profile Statistics

  Number of INSERT, DELETE and UPDATE statements00000000000.0000

  Rows affected by INSERT, DELETE, or UPDATE statements00000000000.0000

  Number of SELECT statements 01000000010.2000

  Rows returned by SELECT statements06800000003710.5000

  Number of transactions 00000000000.0000

  Network Statistics

  Number of server roundtrips11111111111.0000

  TDS packets sent from client11111111111.0000

  TDS packets received from server131111111223.3000

  Bytes sent from client124941221221601601561569890128.2000

  Bytes received from server30161124830161382221722222222108808510655.1000

  Time Statistics

  Client processing time12204488508198.8000

  Total execution time142533558852181944.8000

  Wait time on server replies253311000210036.0000

  Thanks

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  May 10, 2011 at 6:59 am

  #1322252

  what are you looking to find? Do you have a problem?

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  May 10, 2011 at 7:21 am

  #1322276

  Thanks Colin..

  Client statistics creates very beautiful architecture but how to understand it the red black arrows,up down directions...

  Thanks