Tuning MS SQL application database

To avoid performance issues in medium and large environments, configure the location of the transaction log. If you are using MS SQL as database, you might want to shrink the transaction log or update query optimization statistics.