Set up production sql server

Question

Set up production sql server

Krasavita

SSC-Insane

Points: 23138
More actions
December 5, 2011 at 9:45 am

#249214

Hello,
I need to instal sql server 2008 on my future production server.
Can someone provide me a list of things I need to check to set up proparly a server.
Thank you

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

This is such a general question. There aren't necessarily a specific list of things to set/change on your server without getting into a huge document.

Basic things:

1. pick service accounts that are appropriate and limited in security

2. set max memory

3. Be sure that you have backups setup on a separate physical location

4. Enable Agent and mail, set up appropriate management jobs

5. Limit security access to those that need it

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 2

I'm with Steve. However, this checklist will give you a starting point.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

This is I always can't get it right,how much set max memory?

Thank you

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 4

Krasavita (12/6/2011)
This is I always can't get it right,how much set max memory?
Thank you

It depends on the system, but, in general, you should retain 1-2gb for the OS, so set the upper limit 1-2 less than the total memory on the system.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

I agree with Grant. Leave 2GB for the OS, then set the rest for SQL Server. You can also look at what SQL Server lists for the Target SQL Server memory as a setting.

Krasavita SSC-Insane Points: 23138 More actions · Answer 6

ok, I am in the process of installing,so how can I Leave 2GB for the OS(where do I check for this?)

Thank you

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 7

You check the maximum memory that the OS can see. If you don't know how to do that, search for it. It's a basic item to check, and if you can't do that, you probably should have someone else configure the server.

Substract 2GB from that number, set that as the max memory for SQL Server. Again, if you can't do that, then perhaps you should ask someone else to change things and you can observe and learn.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 8

Krasavita (12/6/2011)
ok, I am in the process of installing,so how can I Leave 2GB for the OS(where do I check for this?)
Thank you

After you do the install, you change this setting on the SQL Server instance. You can do it through TSQL or through SSMS. Right click on the Server name after you connect to it and select properties. There's a memory page. Set the max value there.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Krasavita SSC-Insane Points: 23138 More actions · Answer 9

Message body

1.I went to system configuration,tab boot/advance option,added 2 processors

, is standard for memory maximum is 20480 (always confused with that) should I leave like that?

2. When I install sql server 2008, I need to create accounts, should I use/create the same account/password for all sql server services?

Krasavita SSC-Insane Points: 23138 More actions · Answer 10

when istalling sql server2008

If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and create seperate accounts for sql agent and etc?

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 11

Krasavita (12/6/2011)
when istalling sql server2008
If you look under this screen there is only one option to use the same account for all sql Services,but how can I go and create seperate accounts for sql agent and etc?

Full set of documentation is available from Microsoft. It breaks it down by screen, so you should be fine.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 12

Create your separate accounts in AD, then choose them in the setup screen. You need to create the accounts ahead of time.