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)


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.

| improve this answer | |
  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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