Recently we had a company audit one of our SQL Servers (warehouse mgt system) and they did such a good job we had them do the same thing for our NAV SQL Server. We have NAV 2018 and our database size is around 500 gb. Remember every database is a little different with different hardware so take the following suggestions with a grain of salt. Also this is a list of things that might be a little less known but certainly is not all inclusive, so add things if you would like.
If you've found this thread useful, dive deeper into User Group community content by role