Problem with Client Statistics after changing Connection

• TerlisnerM

  SSC Enthusiast

  Points: 181

  More actions

  February 16, 2011 at 3:30 pm

  #232269

  I’m having a problem with Client Statistics and I need help...

  I’m trying to compare how fast a particular query runs on two databases (dev/test). When I first open the query in SSMS, select "Include Client Statistics", and execute the query, it works as expected and shows meaningful client statistics every time I run it, as long as I stay on the same connection. The issue is, as soon as I "Change Connection" (or disconnect/re-connect), all future runs show 0 for every client statistic.

  It’s easy enough to work around – I can simply close/re-open the file, and choose the new connection. The only caveat is that I can't have any other query windows open, since it would automatically re-use the same connection, and I need it to prompt me to choose the new connection. Sometimes even then it doesn't prompt me, so I need to close/re-open SSMS.

  Even though the work-around is simple enough, it seems like this shouldn’t need a work-around – SSMS seems so robust about handling everything else, that I wonder if I’m missing something. Is there something else that I need to do or configure?

  Thanks

  -Mitch