on 07-09-2013 2:23 AM
Hello, i'm trying to install SQL server 2012 "manually", and i just can't find information on best practices for System Database directory and other paths that installation requires.
My question is -> what is the best practice for separating the following components for different disks:
Shared Features
Default Instance
System Database
Thanks
Hi Pedro,
The IO workload on default data directory
is so small. Personally, I will put all data in C:\ just because it is easier to use. When you install SAP on SQL using SWPM later, you have to distribute the most important database files to each LUN.
ex:
<SID>Data 1~4: LUN 1
<SID>Data 13~16: LUN 4
TempDBF 1: LUN 1
TempDBF 4: LUN 4
<SID>Log 1: LUN 5
TempLog 1: LUN 5
see Juergen's best practice doc here. ( http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548... )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all for the answers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pedro,
that very much depends on the type of storage you are using (SAN, NAS, DAS and so on). If I had no restrictions I would go for something like that:
LUN1: OS
LUN2: pagefile
LUN3: SQL Server with all components mentioned above + master, model, msdb
LUN4: SAP executables
LUN5: tempdb
LUN6: <SID>Logfile (write performance is important)
LUN[7..n]: <SID>DATA[1..n] (read performance is important)
LUN[n+1]: TA-Log backup
LUN[n+2]: DB backup
For the tempdb, logfile and datafiles you might also want to consider using SSD drives. At least these 3 types of files I would always put on seperate DISKs/LUNs.
Regards,
Sven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pedro
You need to isolate System Swap(Page filesystem), System Databases, Tempdb, and User Databases to separate disks (LUNs), this can be done bases on your storage. if you are using internal disks isolate to different RAID sets. It is strongly suggested do not Share tempdb and other dbs LUNS. this helps reduce DISK I/O overhead.
Let me know if you have further questions i am happy to answer.
-giri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.