Current database is almost 200GB however the transaction log file is only 4.1GB. I am worried if this influences the performance of databse and how could it be solved.
When I do this query
DECLARE @DatabaseName VARCHAR(50) ; SET @DatabaseName = 'dbname' SELECT name , recovery_model_desc , log_reuse_wait_desc FROM sys.databases WHERE name = @DatabaseName Show Recovery Model = Simple, Log Reuse Wait = Nothing.
Anyone has a knowledge why the log file is so small, and does this influences on the performance?