MS SQL Data Transmission Bandwidth

[sam4help]

Dears All,

I am in fix one of client has asked for what size of data bandwidth usage application eat up.
Can some one help me in this? its a just simple transactions like a search a db and display simple row of data. but some time it may need to return multiple rows of data but each row will not have more than max 4-5 columns. this is the first time someone has asked such question and we know its just to show off and trouble us.

what is the normal reply given such time if someone asks?

Best regards,

Sam

 

[sam4help]

nobody ....

 

[sam4help]

Any 1????

 

[notadba]

I think your question may be too broad. Data bandwidth is more than likely related to network traffic rather than anything on the database.

You can probably provide some data based on the client statistics based on some of the sql being passed. You will need to identify some common or long running SQL being passed and run this through SQL management studio and see what the results provided.

Hope this is of some help.

 

[sam4help]

Ok, thanks notadba. We were also thinking on the same line, and felt that it can only be judged after application development is done.
They are just trying to harass by asking such baseless questions before even developing the application .. anywayz thanks again,

Best Regards,

Sam

 

[philhege]

If you're cornered and must provide the data, you can start with something like this.

-----------
With business clients like mine, you'd be better off herding cats.

 

[sam4help]

thanks philhege that looks like it may come helpful in some dire situation ..