Recommended Auto Grow settings suitable for database whose size is 867666.25 MB I need recommendations for setting/modifying the auto grow options for our production database.

size of FUNDSDB  867666.25 MB   

Also, 
I have attached the current autogrowth statistics , looks like it is set to 200 MB which I think is considerably less considering the database size and also it should be modified to some realistic value else these auto-growth events can cause performance degradation for our current db transactions.



Can anyone suggest the auto growth settings best suitable for this heavy OLTP production database?
We are using SQL Server 2012 standard RTM version currently.
The main reason we are planning to change the autogrowth factor is that we have observed, we are experiencing frequent up to 11 times auto grow a day and also, many frequent CPU spikes.
Set it to 1024MB.  If it is still happening too often, then 4096MB.  Until you measure your actual growth needs, it guesswork.

Or, manually grow it to 950GB, or an even 1TB and let Autogrow not be a factor, which is what you should be doing anyway.

Is Instant File Initialization turned on?  You didn't mention the version of SQL Server.

And change the Log file from % to MB.

And just for bonus - please get them onto separate drives.

Kevin3NF