SQLServerCentral.com / Administering / SQL Server 2005 / Sql Server (Recommended) Configuration Settings : 2000 & 2005 / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 18:40:15 GMT20RE: Sql Server (Recommended) Configuration Settings : 2000 & 2005http://www.sqlservercentral.com/Forums/Topic564993-146-1.aspxYou MUST change the defaults for TempDB or you'll end up having 73 fragments by the time it grows to 1GB.I normally start out a new system with 1000MB allocated to the mdf and 200MB-250MB allocated to the ldf. I setup the growth on the mdf to 250MB and 100MB on the LDF. Then, I watch it for a month. After at least one "month-end crunch" has passed, I'll set the sizes to whatever the current sizes are + 20% and bounce the service so I have a nice contiguous TemDB where the growth isn't going to take anyone by surprise.Sun, 07 Sep 2008 11:16:12 GMTJeff ModenRE: Sql Server (Recommended) Configuration Settings : 2000 & 2005http://www.sqlservercentral.com/Forums/Topic564993-146-1.aspx3.24GB of RAM? Is this a 3GB or 4GB machine?There are no real configuration settings that you need to change. However it completely depends on what you are doing with the server and what performance you need.Sat, 06 Sep 2008 20:16:50 GMTSteve Jones - SSC EditorRE: Sql Server (Recommended) Configuration Settings : 2000 & 2005http://www.sqlservercentral.com/Forums/Topic564993-146-1.aspxYour post indicates a 160 GB HDD - is this a SATA, ATA, or IDE drive ?In order to insure data integrity, the disk drive cache must be disabled or writes will be lost causing the database to become corrupt.Please read "Description of using disk drive caches with SQL Server that every database administrator should know" at http://support.microsoft.com/kb/234656Sat, 06 Sep 2008 08:22:17 GMTCarl FederlRE: Sql Server (Recommended) Configuration Settings : 2000 & 2005http://www.sqlservercentral.com/Forums/Topic564993-146-1.aspxIn general the defaults are pretty good and in most cases shouldn't be changed unless you have a good reason. The exception is the max memory if the server in question has lots of memory (which your doesn't)It's usually recommended that the OS, the SQL data file and the log files all go onto separate physical drives. You only appear to have one drive, so that's not possible.p.s. Please post in the appropriate forum next timeSat, 06 Sep 2008 04:52:17 GMTGilaMonsterSql Server (Recommended) Configuration Settings : 2000 & 2005http://www.sqlservercentral.com/Forums/Topic564993-146-1.aspxKindly provide Sql Server (Recommended) Configuration Settings : 2000 & 2005. I have gone through various resources available online. But unable to find complete list of Recommended Configuration Settings.Server Details :Intel(R) Core 2 DUO CPU E 6850 @ 3.00 GHz2.99 GHz, 3.24 GB of RAM 160 GB HDDOS : Windows 2003 Server RgdsMohan KumarSat, 06 Sep 2008 00:51:22 GMTMohan Kumar VS