August 23, 2016 at 2:45 am
Any thoughts on this setup for disks
Total disks: 6 Std HD + 6 SSD
OS - HD - RAID 1
SQL SERVER - HD - RAID 1
BACKUPS - HD - RAID 1
LOG - SSD - RAID 1
DATA - SSD - RAID 10
Reason I've separated LOG and DATA is in case of either subset of disks failing rather than all on SSD RAID 10.
Temp DB data will be on the DATA drive and log on the LOG drive.
Temp DB is around 500 MB but once grew to 2 GB
August 23, 2016 at 5:14 am
bugg (8/23/2016)
Any thoughts on this setup for disksTotal disks: 6 Std HD + 6 SSD
OS - HD - RAID 1
SQL SERVER - HD - RAID 1
BACKUPS - HD - RAID 1
LOG - SSD - RAID 1
DATA - SSD - RAID 10
Reason I've separated LOG and DATA is in case of either subset of disks failing rather than all on SSD RAID 10.
Temp DB data will be on the DATA drive and log on the LOG drive.
Temp DB is around 500 MB but once grew to 2 GB
Keep tempdb away from user databases and that includes it's log file. Put all tempdb files on same disk but separate the log if you can.
There's not much more you can do given the limited number of disks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2016 at 6:11 am
Thanks Perry, if i keep Temp DB by itself on a SSD RAID 1
That leaves me a few options:
1) LOG file with DATA on RAID 10
2) LOG file with BACKUPS in RAID 1 Standard drives 15Ks
3) LOG file with SQL Server files RAID 1 Standard drives 15Ks
Leaning towards options 2 or 3 to keep LOG and DATA separate.
Which would you go for?
August 24, 2016 at 7:40 am
Anyone have any suggestions, if I keep TempDb on its own RAID 1 array where would the best place be for the log?
Thanks B
August 25, 2016 at 1:39 am
How about installing SQL Server on the same RAID subset as the OS?
This frees up RAID 1 disks for the LOG files.
August 25, 2016 at 3:09 am
I've decided to go LOG files with Backups as the backups are easy to move if i spot any contention/issues.
August 29, 2016 at 2:29 am
bugg (8/25/2016)
I've decided to go LOG files with Backups as the backups are easy to move if i spot any contention/issues.
Any ones thoughts on this? Also I've been thinking of backing up to the mirror server which will have the same RAID setup.
August 31, 2016 at 6:45 am
keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then do so.
do not put the log files on the backup drive keep backup files separate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2016 at 12:49 pm
Perry Whittle (8/31/2016)
keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then do so.do not put the log files on the backup drive keep backup files separate
Thanks Perry whats your thinking behind this? Separating the tempdb log from its data file?
Best I can do with my disks is to put all of TempDB (data + log) with the user DB log files.. If that is better then user logs and backups together?
September 2, 2016 at 10:40 am
bugg (8/31/2016)
Perry Whittle (8/31/2016)
keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then do so.do not put the log files on the backup drive keep backup files separate
Thanks Perry whats your thinking behind this? Separating the tempdb log from its data file?
Best I can do with my disks is to put all of TempDB (data + log) with the user DB log files.. If that is better then user logs and backups together?
Tempdb should be separate from user database files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply