Tuning MS SQL Server application database

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