Bandwidth check?

Hi there.

a Quick question, and a stupid one may I add!

How can I check how much bandwidth is being used in a query to be executed, running SQL Server 2000 in bytes/KB?

I would like to know how to do this in both, 2000 and 2005 if possible. I just want to see if I am doing things correctly and effeciently, I believe I am, but also would like to make sure I am not over using my bandwidth from the web hosting point of view also.

Thanks!

Hi ahmedilyas,

Include Client Statistics. In QA or Managment Studio, elect to display the client statistics in the tsql editor, in Mgmt Studio (as I am looking at it right now) there is a section of the returned client stats labeled "network statistics", it includes the number of TDS packets sent across the wire etc...

Hope this helps,

Derek

sql