Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

understanding client statistics information in sql 2008 Expand / Collapse
Author
Message
Posted Monday, January 07, 2013 11:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:00 AM
Points: 76, Visits: 120
I just want to know how exactly client statistics works and as DBA for query performance what parameter has to be understood technically from client statistics tab of ssms.
I know it it gives info abt network,query profile and time.
whether the time parameter displayed is in miliseconds?
Post #1403988
Posted Tuesday, January 08, 2013 1:38 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:41 PM
Points: 494, Visits: 325
http://blog.sqlauthority.com/2009/10/01/sql-server-sql-server-management-studio-and-client-statistics/

And yes, the times are milliseconds.




Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1404045
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse