bandwidth usage -- website, with microsoft sql backend

I am thinking about converting to
but want to know my costs.

How can I find out how much total usage (both LAN and WAN) my locally hosted website and MS SQL backend are using ?
Who is Participating?
giltjrConnect With a Mentor Commented:
Unless somehow you can separate traffic out by IP address and/or tcp port there is nothing you can do from the network side.  The network does not know about sites/hostnames/database names/table names, just IP addresses and TCP ports.

On the webserver you should be able to look at the log entries.  Not sure in IIS if you can create a unique log for each site (I think it can) or not (I know Apache can).  At a minimum you should be able to log which site/hostname each message is from.  With this you can see how much traffic is going out to the browser, but I don't think you can tell how much traffic came in from the browser.

On the DB side, I have no clue if  MS SQL Server has some type of accounting where you can identify by DB/Table traffic.
Do you have managed switches?

If so you could use something like MRTG, PRTG, or any other SNMP enabled networking monitoring tool to measure the traffic on the ports the servers are connected to.

If you don't have managed switches you can still use those programs, but you would need to enable SNMP on your servers and query the servers directly.
finance_teacherAuthor Commented:
My issue is the webserver hosts multiple websites and the database server hosts multiple databases.

I just want to see how bandwidth usage on 1 website and 1 database.

Any ideas ?
InfamusConnect With a Mentor Commented:
We have moved couple of our web servers to Azure and Microsoft sent us tool to calculate the usage.  Why don't you contact them and their sales engineer will be able to help you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.