SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server installation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Abu-Dina
Posting Yak Master

United Kingdom
206 Posts

Posted - 11/19/2012 :  08:02:47  Show Profile  Reply with Quote
Guys, apologies in advance for posting this here also (posted on SSC as well) but since I've had no replies I thought I'd try my luck here...

Need to install SQL Server on a new box. OS installed and ready etc...

The server has two drives:

C - RAID 1 across two 46GB drives
D - RAID 5 across 3 600GB drives

The new server is not in the trusted domain so can't use AD accounts.

See below of another server that was configured by someone else a few years back but I don't like the fact that the services are using the Administrator account?!



So my plan for the SQL Server installation is as follows:

1) Create new local accounts and let SQL Server assign the required permissions.
2) Ensure Anti-Virus software skips .MDF, .LDF and .NDF files
3) Enable Instant File Initialisation.
4) Use drive C for SQL Server installation and drive D for .MDF and .LDF files (including TempDB).

Is this okay?

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2039 Posts

Posted - 11/19/2012 :  11:11:48  Show Profile  Visit jackv's Homepage  Reply with Quote
1) OK
2) good idea
3) yes
4) Ideally separate out data , log , tempdb into different IO channels

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Abu-Dina
Posting Yak Master

United Kingdom
206 Posts

Posted - 11/19/2012 :  12:03:07  Show Profile  Reply with Quote
quote:
Originally posted by jackv

1) OK
2) good idea
3) yes
4) Ideally separate out data , log , tempdb into different IO channels

Jack Vamvas
--------------------
http://www.sqlserver-dba.com



Thanks Jack.

The server has already been configured so i can't really change it. I'm stuck with just trhe two drives C and D.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2039 Posts

Posted - 11/21/2012 :  10:46:24  Show Profile  Visit jackv's Homepage  Reply with Quote
OK, maybe that is something to consider for the future - if you need to resolve some IO bottleneck issue

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000