My company is new to SharePoint. We have an on-premise installation with the file size limit set to the default of 250 mb. We've had a request to increase that limit to 500 mb. The Microsoft article on boundaries and limits states that
By default, the default document size threshold is set to 250 megabyte (MB), but can be changed to support the maximum boundary of 10 GB.
In the same article, Microsoft states that
The default file size is 2 gigabytes (GB) (2,047 MB). However, a large volume of very large files can affect farm performance.
I'm trying to identify the risks for the proposed increase. Content database limits are a risk. Are there others we need to evaluate? I can find a number of resources related to SharePoint 2010, but nothing for SharePoint 2016.