Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Our compagny has a central Sql Server Database which is connected to many applications (Web, Backend/Frontend services, backoffice, ..) This database is hosted in a small country (for taxing advantages) where bandwidth is expensive.

Is there any way to have a detailed view of bandwidth usage ? such as how bytes are sent per application, per stored procedure, per login...

I want to monitor this at Sql Server because I can not do this at client side (too many clients and it is not suitable to alter client code for that)

share|improve this question

migrated from stackoverflow.com Jan 14 '13 at 12:43

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 4 down vote accepted

You can snap sys.dm_exec_connections which will give you the net IO metrics for any given connection. The associated sys.dm_exec_sessions will identify the connection client (host, application). Since you need aggregated history and the view gives moment in time snapshot you will have to do the usual transformations to convert moment-in-time to aggregate history.

share|improve this answer
1  
perfect ! thanks –  Cybermaxs Jan 14 '13 at 11:58
    
it is possible to have a similar thing for sp exec ? Because in fact, I have only one major connection ... –  Cybermaxs - Betclic Jan 16 '13 at 14:46
1  
no. is not because is not captured, is simply because the concept you ask for does not exists. You can infer some from the execution statistics sys.dm_exec_query_stats by assuming that a higher number of total_rows implies more network writes. –  Remus Rusanu Jan 16 '13 at 14:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.