I have set the
maxsize properties to:
By 10 MB, Unlimited
When I look at the Properties -> General Tab by right-clicking the database in SSMS, I see the file size is 2249MB with 6.1 MB of space available. What does this mean?
I have 700 GB free space remaining on the drive where the log file and database file sits. The log file does have a limit of 2097152 MB. It looks like that space available means log file space?
In terms of database performance, how does the size of the database and log files affect reads and writes?