c# - Logging a lot of operations efficiently -


we want go deeper on logging @ work , planning log virtually every important thing happening in our system, such audit operations performed on db tables , other business operations happening in system , in services thereof, generate thousands of records every couple of hours.

the logging system should - of course- easy use , configure, , able queried real-time.

my questions are:

1) can "the audit operations on db" part handled sql-server itself? have own logging mechanism?

2) how , can log other business operations?

first framework comes mind log4net, i'm still not sure log them don't want overfill db time. using whole different db logging purposes, or producing text files out of db periodically , zipping them, etc. way? how enormous systems handle kind of elaborated logging processes?

log4net has whole bunch of appenders can configure in app.config , change without need rebuild anything, can have database appenders, smtpappenders, rolling file appenders , many many others, no special coding got working , sending me emails using smtpappender small applications. if decide change appender touch configuration.

sql server supports audit , change tracking, should have need , more, careful in general if enable many things may have performance issue.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -