Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Abu-Dina
Posting Yak Master
206 Posts |
 Posted - 2012-11-19 : 08:02:47
|
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 drivesD - RAID 5 across 3 600GB drivesThe 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 files3) 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
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-19 : 11:11:48
|
| 1) OK2) good idea3) yes4) Ideally separate out data , log , tempdb into different IO channelsJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Abu-Dina
Posting Yak Master
206 Posts |
Posted - 2012-11-19 : 12:03:07
|
quote:
Originally posted by jackv
1) OK2) good idea3) yes4) Ideally separate out data , log , tempdb into different IO channelsJack 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. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-11-21 : 10:46:24
|
| OK, maybe that is something to consider for the future - if you need to resolve some IO bottleneck issueJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
SQL Server installation