Click here to monitor SSC
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
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
Points: 284 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-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47255 Visits: 44386
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
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2336 Visits: 4349
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-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36130 Visits: 18744
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-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45110 Visits: 39915
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

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