understanding client statistics information in sql 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » understanding client statistics information...

understanding client statistics information in sql 2008

Rate Topic

Display Mode

Topic Options

Author

Message

sej2008

Posted Monday, January 07, 2013 11:59 PM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 1:12 AM
Points: 82, Visits: 134

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

Vegard Hagen

Posted Tuesday, January 08, 2013 1:38 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 10, 2013 5:46 AM
Points: 500, Visits: 337

http://blog.sqlauthority.com/2009/10/01/sql-server-sql-server-management-studio-and-client-statistics/

And yes, the times are milliseconds. Smile

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 »

Permissions