We need to log user and file activity from several servers into a centralized database on a separate server. We are trying to determine the best method to use to allow for scalability. There may be a lot of data being logged into the database as we add the logging from additional servers. Most of the data that is being logged would include things like user session logins and file access.
We have identified several options to send the data from each of the servers into the centralized database: SQL Server messaging, MSMQ/BizTalk, Deploy nServiceBus, WCF Routing Service, and AppFabric Service Bus. Does anybody know of a reason that one of these approaches or something similar might be far better than any of the others to do something like this?