February 1, 2010 at 4:15 am
HD size is total 653 gb,
There are two data file as
1. fdcrt_data size is (124216), 2. fdcrt_1_Data size is (165406), so total db size 289 gb.
2. both log files totaly 10 mb after shirnking.
datafile Setting currently this server
----------------------------------
1. database recovery model - simple. (we dont want tlog bkp and point in time recovery)
2. data file 10% auto growth and unrestricted file growth for both files.
3. Log files 10% auto growth and unrestricted file growth for both files.
4. Auto shirnk - on.
Please reply me good sloution , above setting is it fine for future capacity plan?
Thanks for advance(SQLDBAs)
February 1, 2010 at 4:25 am
In order to do capacity plan, it is more important to know or have an estimation about the database growth. There is a huge difference if you estimate that the database will grow by 1MB each month or if you estimate that it will grow by 200GB each month. Without this data, no reader will be able to help you with the capacity plan. One thing that I would recommend is not to specify the file growth with percentage. It is better to specify it by megabytes. Also it is better to monitor the free space and in case that only little space is left manually add big chunk to the file and not rely on the automatic growth which should be done with small chunks.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 1, 2010 at 6:59 pm
Yes,I do agree with Adi.Atleast I would not recommend the autogrowth option in % for log file.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply