DOC-ID 80: I am planning on or already using EventSentry on remote sites with limited bandwidth availability, but would like to consolidate events and other data in a central database. Which database uses more bandwidth, and how much bandwidth (network traffic) does event log consolidation use?
| Applies to: EventSentry (all versions) | Category: Database |
| Document Created: 2006-03-25 | Document Last Modified: 2006-04-04 |
We have compared network traffic used between Microsoft SQL Server and MySQL in a scenario where one event log entry is logged to a database. In this scenario EventSentry connected to the database server, transferred one event log entry (with approximately 200 characters), and disconnected from the database.
In this test we measured the following:
Microsoft SQL Server 2000 (without encryption):
~2.7kb for one event + TCP session setup
~1.6kb for each additional event
Microsoft SQL Server 2000 (with encryption):
~5kb
MySQL v5.x
~1.7kb for one event + TCP session setup
~1kb for each additional event
Oracle:
~10.5kb for one event + TCP session setup
~3.4kb for each additional event
As such, if you have limited bandwidth available and plan on transferring a significant amount of information over WAN links then MySQL and MSSQL will use less network traffic than Oracle.