If I understood correctly, Webservices running on WebTier want to log into
Database. We used Splunk for logging everything from DB and WebTier.
Agree with you, it is over kill to log in DB. Other option you can load log
files written by WebTier using scheduler to DB in interval.
Karth
On Jan 15, 2016, at 5:50 PM, Jeff <backseatdba@xxxxxxxxx> wrote:--
I know this is not directly a DBA question but I thought maybe someone would
have some experience.
My web team is wanting to implement a logging service which will log all
calls to their web services and info about who and what was called. And so
they are wanting to store this in the database in some table or tables.
Which basically means that every call to the database will generate an
additional call for logging. To me this seems like a bad idea to store in the
database. I am either thinking of creating a separate database just for
logging or well I don't know. I suggested just writing it all to a file and
use something like Splunk but for some reason which I haven't found out yet
they said that would not work for them.
Any suggestions/advice? Is this normal practice to log back to the database?