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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-03-21 : 09:54:17
|
| we have SQL SERVER for BI System.today i invited BI and DataBase counselor ,he recommende us to :put inDISK11. OS+tempdb on 146 G*2 RAID 1+0DISK22.DataBase+Log ON 750 G RAID 53.BackUp ON 750 G RAID 5my question, i read that the recommendation is to seperate DB and log to difffrent disk,in my case why i need to put them together?(all my dbs is 250 G and log is 8 G ) |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-23 : 06:24:48
|
quote:
Originally posted by inbs
we have SQL SERVER for BI System.today i invited BI and DataBase counselor ,he recommende us to :put inDISK11. OS+tempdb on 146 G*2 RAID 1+0DISK22.DataBase+Log ON 750 G RAID 53.BackUp ON 750 G RAID 5my question, i read that the recommendation is to seperate DB and log to difffrent disk,in my case why i need to put them together?(all my dbs is 250 G and log is 8 G )
it is advised, but not mandatory. It depends on the system. You should ask the consultant to provide you with a reason for the settings. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-03-23 : 07:52:01
|
| i read some article and they said 'that db and log can not set in the same disk.my consultant said the reason to put the db and log on the same disks,is that our db it is just 250 G and log 8 G. and the most of the transactions run in the night. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-24 : 00:21:25
|
| The ideal architecture separates the data files and the transaction log file, but it just depends on how many disks you have. We separate lots of stuff out. Each of these gets its own set of disks in my environments: tempdb, data files, transaction logs, backups, and the other system databases.For a 250GB database, you should have a minimum of 4 data files as Microsoft's recommendation is that no data file is over 64GB.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-03-24 : 05:22:53
|
| tkizerthe size all my database is 250G (i have 35 Database-35 datafiles in recovery model simple).so it is ok to set data file and Transaction log in same disk? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-24 : 05:24:58
|
quote:
Originally posted by inbs
i read some article and they said 'that db and log can not set in the same disk.my consultant said the reason to put the db and log on the same disks,is that our db it is just 250 G and log 8 G. and the most of the transactions run in the night.
are you sure enough that log size will not be more than 8GB? what relation does night has with transaction log size?you must check the recovery model and backup strategy in order to control the log size. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
BI-SQL