SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql Server (Recommended) Configuration Settings : 2000 & 2005


Sql Server (Recommended) Configuration Settings : 2000 & 2005

Author
Message
Mohan Kumar VS
Mohan Kumar VS
Mr or Mrs. 500
Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)Mr or Mrs. 500 (502 reputation)

Group: General Forum Members
Points: 502 Visits: 344
Kindly 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 GHz
2.99 GHz, 3.24 GB of RAM
160 GB HDD
OS : Windows 2003 Server

Rgds
Mohan Kumar
GilaMonster
GilaMonster
SSC Guru
SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)SSC Guru (210K reputation)

Group: General Forum Members
Points: 210726 Visits: 46251
In 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 time

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Carl Federl
Carl Federl
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6542 Visits: 4351
Your 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/234656

SQL = Scarcely Qualifies as a Language
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139015 Visits: 19406
3.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.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202933 Visits: 41947
You 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.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search