We are running SQL Server 2000. I would like input on the recommended
settings for the following:

Database settings:
1) Data Files - When you automatically grow the file, should
you use a % or megabytes?
2) Transaction Log Files - When you automatically grow the
file, should you use a % or megabytes?
3) Recovery Model - Since this is a production database and we
will performing transaction log backups, I am assuming we should use the
Full Model.
4) Options - Settings - Here is what is currently set (see below or
attachment)



Server Settings
1)






Memory - Currently configured to "dynamically configure SQL Server
memory"
2) Processor - Currently configured to "use of available processors"
3) Security -







Authentication is set to "SQL Server and Windows"
Audit Level is set to "None"
4)








Database Settings - Default index fill factor to use when rebuilding
indexes is unchecked








New database default location boxes are empty


Thanks!
-Bill





MS Sql Server LazyDBA home page