What is the maximum value for Event Log Size

The larger the log the more performance issues you will have. If you have meta type changes enabled your event log will get very large very quick. During development, I will set it to 20,000 to get a history of what's going on but then reduce it to 7000 or less and turn off logging meta changes.

So I don't believe there is a max but know the more data you have in there the slower it will be. I had a client a few months back that didn't manage their data and their database was over 150GB in size and their event log couldn't keep up because of so many other errors with nearly every request and they had their event log set to 50,000. Needless to say, keeping your database clean is better than gumming it up.

Thanks Brenden for quick response!

I will try to set this value of our site(not global) to 2000 and turn off logging meta changes.

Thanks!

There really isn't any hard maximum, but I would generally recommend one of the following:

• Either keep it under 100k for all web sites in your instance, the lower the better. The more you have, the slower the cleaning process gets. More powerful SQL server can handle more, but it may be unnecessary waste of resources

• Or keep it unlimited (set to 0), and clean event log on regular basis with regular table truncate based on how much you can afford your database to grow

In case you experience some repeating issues, it is typically no problem to find proper information for resolving issues in the last day of events.

It is also a good idea to make a snapshot of current log if you contact support with some event log errors, because they may ask you about what was happening before and after to narrow down the cause.