I am new to SQL DBA Administration. Please help me understand the below scenario.
As it is really confusing. Please help.
What does it mean keeping the Auto Growth in Percentage.
My SQLLOG Drive (E:) is 300 GB in total.
If I keep 10 % Auto Growth will it take 10% of 300 GB which is 30 GB.
Every time the transaction file needs space it occupies 30 GB of total 300 GB ?
What does 10% Auto Growth mean actually ?
To which file this 10% Auto Growth applies and how space is utilized based on this Auto Growth 10 % ?
Please help me understand this scenario.